Dataset statistics
| Number of variables | 64 |
|---|---|
| Number of observations | 6087 |
| Missing cells | 33479 |
| Missing cells (%) | 8.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 3.0 MiB |
| Average record size in memory | 520.0 B |
Variable types
| Numeric | 13 |
|---|---|
| Categorical | 24 |
| DateTime | 2 |
| Boolean | 25 |
asset_backed has constant value "" | Constant |
oid has constant value "" | Constant |
slob has constant value "" | Constant |
issue_offered_global has constant value "" | Constant |
unit_deal has constant value "" | Constant |
form_of_own has constant value "" | Constant |
bond_type has constant value "" | Constant |
greater_of has constant value "" | Constant |
lesser_of has constant value "" | Constant |
prospectus_issuer_name has a high cardinality: 1069 distinct values | High cardinality |
issuer_cusip has a high cardinality: 1078 distinct values | High cardinality |
issue_cusip has a high cardinality: 1471 distinct values | High cardinality |
issue_name has a high cardinality: 227 distinct values | High cardinality |
delivery_date has a high cardinality: 1744 distinct values | High cardinality |
isin has a high cardinality: 6080 distinct values | High cardinality |
complete_cusip has a high cardinality: 6087 distinct values | High cardinality |
effective_date has a high cardinality: 1767 distinct values | High cardinality |
dated_date has a high cardinality: 1761 distinct values | High cardinality |
first_interest_date has a high cardinality: 1583 distinct values | High cardinality |
last_interest_date has a high cardinality: 2515 distinct values | High cardinality |
issue_id is highly overall correlated with amount_outstanding and 3 other fields | High correlation |
gross_spread is highly overall correlated with selling_concession and 3 other fields | High correlation |
selling_concession is highly overall correlated with gross_spread and 3 other fields | High correlation |
offering_price is highly overall correlated with comp_neg_exch_deal and 1 other fields | High correlation |
offering_yield is highly overall correlated with gross_spread and 3 other fields | High correlation |
principal_amt is highly overall correlated with subsequent_data and 2 other fields | High correlation |
action_price is highly overall correlated with mtn and 6 other fields | High correlation |
action_amount is highly overall correlated with mtn and 4 other fields | High correlation |
amount_outstanding is highly overall correlated with issue_id | High correlation |
coupon is highly overall correlated with gross_spread and 2 other fields | High correlation |
years_to_maturity is highly overall correlated with gross_spread and 2 other fields | High correlation |
coupon_type is highly overall correlated with interest_frequency and 2 other fields | High correlation |
mtn is highly overall correlated with action_price and 4 other fields | High correlation |
yankee is highly overall correlated with sec_reg_type1 and 1 other fields | High correlation |
canadian is highly overall correlated with sec_reg_type1 | High correlation |
comp_neg_exch_deal is highly overall correlated with offering_price and 2 other fields | High correlation |
rule_415_reg is highly overall correlated with issue_id | High correlation |
sec_reg_type1 is highly overall correlated with offering_price and 3 other fields | High correlation |
denomination is highly overall correlated with yankee | High correlation |
defeased is highly overall correlated with action_price and 4 other fields | High correlation |
defaulted is highly overall correlated with action_price and 2 other fields | High correlation |
tender_exch_offer is highly overall correlated with action_type | High correlation |
refund_protection is highly overall correlated with action_price and 4 other fields | High correlation |
overallotment_opt is highly overall correlated with selling_concession and 2 other fields | High correlation |
active_issue is highly overall correlated with issue_id and 2 other fields | High correlation |
subsequent_data is highly overall correlated with principal_amt and 4 other fields | High correlation |
action_type is highly overall correlated with tender_exch_offer and 2 other fields | High correlation |
see_note is highly overall correlated with offering_yield and 8 other fields | High correlation |
interest_frequency is highly overall correlated with coupon_type and 2 other fields | High correlation |
pay_in_kind is highly overall correlated with issue_id and 7 other fields | High correlation |
coupon_change_indicator is highly overall correlated with coupon_type and 2 other fields | High correlation |
day_count_basis is highly overall correlated with coupon_type and 2 other fields | High correlation |
issue_name is highly imbalanced (59.8%) | Imbalance |
security_level is highly imbalanced (88.6%) | Imbalance |
mtn is highly imbalanced (99.6%) | Imbalance |
canadian is highly imbalanced (86.0%) | Imbalance |
settlement_type is highly imbalanced (98.9%) | Imbalance |
comp_neg_exch_deal is highly imbalanced (71.7%) | Imbalance |
sec_reg_type1 is highly imbalanced (54.1%) | Imbalance |
denomination is highly imbalanced (71.7%) | Imbalance |
covenants is highly imbalanced (81.5%) | Imbalance |
defeased is highly imbalanced (99.8%) | Imbalance |
defaulted is highly imbalanced (99.8%) | Imbalance |
redeemable is highly imbalanced (52.3%) | Imbalance |
refund_protection is highly imbalanced (99.8%) | Imbalance |
overallotment_opt is highly imbalanced (99.4%) | Imbalance |
announced_call is highly imbalanced (95.8%) | Imbalance |
dep_eligibility is highly imbalanced (94.6%) | Imbalance |
see_note is highly imbalanced (98.6%) | Imbalance |
interest_frequency is highly imbalanced (79.1%) | Imbalance |
pay_in_kind is highly imbalanced (99.6%) | Imbalance |
coupon_change_indicator is highly imbalanced (72.4%) | Imbalance |
day_count_basis is highly imbalanced (59.3%) | Imbalance |
gross_spread has 348 (5.7%) missing values | Missing |
selling_concession has 1206 (19.8%) missing values | Missing |
offering_price has 100 (1.6%) missing values | Missing |
offering_yield has 1058 (17.4%) missing values | Missing |
subsequent_data has 2506 (41.2%) missing values | Missing |
action_price has 4998 (82.1%) missing values | Missing |
action_amount has 4746 (78.0%) missing values | Missing |
greater_of has 5322 (87.4%) missing values | Missing |
lesser_of has 5322 (87.4%) missing values | Missing |
see_note has 5322 (87.4%) missing values | Missing |
pay_in_kind has 2502 (41.1%) missing values | Missing |
offering_yield is highly skewed (γ1 = 70.91490893) | Skewed |
principal_amt is highly skewed (γ1 = 61.2777128) | Skewed |
action_amount is highly skewed (γ1 = 36.31222246) | Skewed |
isin is uniformly distributed | Uniform |
complete_cusip is uniformly distributed | Uniform |
issue_id has unique values | Unique |
complete_cusip has unique values | Unique |
offering_price has 204 (3.4%) zeros | Zeros |
amount_outstanding has 2079 (34.2%) zeros | Zeros |
Reproduction
| Analysis started | 2023-08-14 16:50:52.823346 |
|---|---|
| Analysis finished | 2023-08-14 16:51:24.735891 |
| Duration | 31.91 seconds |
| Software version | ydata-profiling vv4.1.2 |
| Download configuration | config.json |
issue_id
Real number (ℝ)
HIGH CORRELATION  UNIQUE 
| Distinct | 6087 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 766994.93 |
| Minimum | 570533 |
|---|---|
| Maximum | 1042547 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 95.1 KiB |
Quantile statistics
| Minimum | 570533 |
|---|---|
| 5-th percentile | 583824 |
| Q1 | 634829 |
| median | 744749 |
| Q3 | 895369 |
| 95-th percentile | 1010416.8 |
| Maximum | 1042547 |
| Range | 472014 |
| Interquartile range (IQR) | 260540 |
Descriptive statistics
| Standard deviation | 144304.64 |
|---|---|
| Coefficient of variation (CV) | 0.18814289 |
| Kurtosis | -1.2858222 |
| Mean | 766994.93 |
| Median Absolute Deviation (MAD) | 124640 |
| Skewness | 0.32786087 |
| Sum | 4.6686981 × 109 |
| Variance | 2.082383 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 570539 | 1 | < 0.1% |
| 849247 | 1 | < 0.1% |
| 849765 | 1 | < 0.1% |
| 849579 | 1 | < 0.1% |
| 849577 | 1 | < 0.1% |
| 849575 | 1 | < 0.1% |
| 849551 | 1 | < 0.1% |
| 849545 | 1 | < 0.1% |
| 849531 | 1 | < 0.1% |
| 849259 | 1 | < 0.1% |
| Other values (6077) | 6077 |
| Value | Count | Frequency (%) |
| 570533 | 1 | |
| 570535 | 1 | |
| 570539 | 1 | |
| 570547 | 1 | |
| 570549 | 1 | |
| 570551 | 1 | |
| 570553 | 1 | |
| 570577 | 1 | |
| 570581 | 1 | |
| 570587 | 1 |
| Value | Count | Frequency (%) |
| 1042547 | 1 | |
| 1042546 | 1 | |
| 1042545 | 1 | |
| 1041125 | 1 | |
| 1040943 | 1 | |
| 1040942 | 1 | |
| 1040939 | 1 | |
| 1040864 | 1 | |
| 1040832 | 1 | |
| 1040686 | 1 |
issuer_id
Real number (ℝ)
| Distinct | 1038 |
|---|---|
| Distinct (%) | 17.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26958.803 |
| Minimum | 13 |
|---|---|
| Maximum | 51608 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 95.1 KiB |
Quantile statistics
| Minimum | 13 |
|---|---|
| 5-th percentile | 534 |
| Q1 | 3879 |
| median | 35354 |
| Q3 | 42177 |
| 95-th percentile | 48129 |
| Maximum | 51608 |
| Range | 51595 |
| Interquartile range (IQR) | 38298 |
Descriptive statistics
| Standard deviation | 18425.671 |
|---|---|
| Coefficient of variation (CV) | 0.68347511 |
| Kurtosis | -1.5643658 |
| Mean | 26958.803 |
| Median Absolute Deviation (MAD) | 10275 |
| Skewness | -0.43132715 |
| Sum | 1.6409823 × 108 |
| Variance | 3.3950534 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 39095 | 104 | 1.7% |
| 32904 | 98 | 1.6% |
| 1664 | 72 | 1.2% |
| 4525 | 64 | 1.1% |
| 263 | 61 | 1.0% |
| 47149 | 56 | 0.9% |
| 42313 | 49 | 0.8% |
| 46381 | 48 | 0.8% |
| 3271 | 48 | 0.8% |
| 1255 | 46 | 0.8% |
| Other values (1028) | 5441 |
| Value | Count | Frequency (%) |
| 13 | 2 | < 0.1% |
| 41 | 10 | |
| 74 | 7 | 0.1% |
| 86 | 3 | < 0.1% |
| 104 | 2 | < 0.1% |
| 121 | 6 | 0.1% |
| 169 | 22 | |
| 187 | 15 | |
| 231 | 9 | |
| 241 | 12 |
| Value | Count | Frequency (%) |
| 51608 | 4 | |
| 51560 | 2 | < 0.1% |
| 51541 | 3 | |
| 51540 | 1 | < 0.1% |
| 51533 | 2 | < 0.1% |
| 51525 | 2 | < 0.1% |
| 51400 | 2 | < 0.1% |
| 51384 | 1 | < 0.1% |
| 51380 | 1 | < 0.1% |
| 51289 | 6 |
prospectus_issuer_name
Categorical
| Distinct | 1069 |
|---|---|
| Distinct (%) | 17.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 95.1 KiB |
| AT&T INC | 104 |
|---|---|
| CITIGROUP INC | 98 |
| WESTPAC BKG CORP | 64 |
| APPLE INC | 61 |
| JPMORGAN CHASE & CO | 56 |
| Other values (1064) |
Length
| Max length | 58 |
|---|---|
| Median length | 49 |
| Mean length | 17.9655 |
| Min length | 5 |
Characters and Unicode
| Total characters | 109356 |
|---|---|
| Distinct characters | 39 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 293 ? |
|---|---|
| Unique (%) | 4.8% |
Sample
| 1st row | AT&T INC |
|---|---|
| 2nd row | SYNOVUS FINL CORP |
| 3rd row | BMC SOFTWARE INC |
| 4th row | AT&T INC |
| 5th row | AFLAC INC |
Common Values
| Value | Count | Frequency (%) |
| AT&T INC | 104 | 1.7% |
| CITIGROUP INC | 98 | 1.6% |
| WESTPAC BKG CORP | 64 | 1.1% |
| APPLE INC | 61 | 1.0% |
| JPMORGAN CHASE & CO | 56 | 0.9% |
| GENERAL MTRS FINL CO INC | 49 | 0.8% |
| SUMITOMO MITSUI FINL GROUP INC | 48 | 0.8% |
| PEPSICO INC | 48 | 0.8% |
| BANK NOVA SCOTIA B C | 46 | 0.8% |
| DISNEY WALT CO | 46 | 0.8% |
| Other values (1059) | 5467 |
Length
| Value | Count | Frequency (%) |
| inc | 2610 | 12.9% |
| corp | 1444 | 7.1% |
| co | 896 | 4.4% |
| group | 396 | 2.0% |
| 395 | 2.0% | |
| finl | 339 | 1.7% |
| new | 274 | 1.4% |
| plc | 258 | 1.3% |
| cap | 247 | 1.2% |
| fin | 246 | 1.2% |
| Other values (1322) | 13132 |
Most occurring characters
| Value | Count | Frequency (%) |
| 14150 | ||
| C | 9477 | 8.7% |
| N | 8665 | 7.9% |
| I | 8093 | 7.4% |
| O | 7680 | 7.0% |
| E | 7470 | 6.8% |
| R | 7191 | 6.6% |
| A | 6494 | 5.9% |
| L | 5309 | 4.9% |
| T | 5142 | 4.7% |
| Other values (29) | 29685 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 94548 | |
| Space Separator | 14150 | 12.9% |
| Other Punctuation | 532 | 0.5% |
| Decimal Number | 97 | 0.1% |
| Dash Punctuation | 29 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 9477 | 10.0% |
| N | 8665 | 9.2% |
| I | 8093 | 8.6% |
| O | 7680 | 8.1% |
| E | 7470 | 7.9% |
| R | 7191 | 7.6% |
| A | 6494 | 6.9% |
| L | 5309 | 5.6% |
| T | 5142 | 5.4% |
| S | 5102 | 5.4% |
| Other values (16) | 23925 |
Decimal Number
| Value | Count | Frequency (%) |
| 6 | 24 | |
| 3 | 17 | |
| 0 | 16 | |
| 2 | 15 | |
| 1 | 15 | |
| 4 | 6 | 6.2% |
| 5 | 4 | 4.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 433 | |
| / | 93 | 17.5% |
| , | 5 | 0.9% |
| . | 1 | 0.2% |
Space Separator
| Value | Count | Frequency (%) |
| 14150 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 29 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 94548 | |
| Common | 14808 | 13.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| C | 9477 | 10.0% |
| N | 8665 | 9.2% |
| I | 8093 | 8.6% |
| O | 7680 | 8.1% |
| E | 7470 | 7.9% |
| R | 7191 | 7.6% |
| A | 6494 | 6.9% |
| L | 5309 | 5.6% |
| T | 5142 | 5.4% |
| S | 5102 | 5.4% |
| Other values (16) | 23925 |
Common
| Value | Count | Frequency (%) |
| 14150 | ||
| & | 433 | 2.9% |
| / | 93 | 0.6% |
| - | 29 | 0.2% |
| 6 | 24 | 0.2% |
| 3 | 17 | 0.1% |
| 0 | 16 | 0.1% |
| 2 | 15 | 0.1% |
| 1 | 15 | 0.1% |
| 4 | 6 | < 0.1% |
| Other values (3) | 10 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 109356 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 14150 | ||
| C | 9477 | 8.7% |
| N | 8665 | 7.9% |
| I | 8093 | 7.4% |
| O | 7680 | 7.0% |
| E | 7470 | 6.8% |
| R | 7191 | 6.6% |
| A | 6494 | 5.9% |
| L | 5309 | 4.9% |
| T | 5142 | 4.7% |
| Other values (29) | 29685 |
issuer_cusip
Categorical
| Distinct | 1078 |
|---|---|
| Distinct (%) | 17.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 95.1 KiB |
| 00206R | 104 |
|---|---|
| 172967 | 95 |
| 345397 | 72 |
| 961214 | 64 |
| 037833 | 61 |
| Other values (1073) |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Characters and Unicode
| Total characters | 36522 |
|---|---|
| Distinct characters | 34 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 304 ? |
|---|---|
| Unique (%) | 5.0% |
Sample
| 1st row | 00206R |
|---|---|
| 2nd row | 87161C |
| 3rd row | 055921 |
| 4th row | 00206R |
| 5th row | 001055 |
Common Values
| Value | Count | Frequency (%) |
| 00206R | 104 | 1.7% |
| 172967 | 95 | 1.6% |
| 345397 | 72 | 1.2% |
| 961214 | 64 | 1.1% |
| 037833 | 61 | 1.0% |
| 46647P | 56 | 0.9% |
| 37045X | 49 | 0.8% |
| 86562M | 48 | 0.8% |
| 713448 | 48 | 0.8% |
| 254687 | 46 | 0.8% |
| Other values (1068) | 5444 |
Length
| Value | Count | Frequency (%) |
| 00206r | 104 | 1.7% |
| 172967 | 95 | 1.6% |
| 345397 | 72 | 1.2% |
| 961214 | 64 | 1.1% |
| 037833 | 61 | 1.0% |
| 46647p | 56 | 0.9% |
| 37045x | 49 | 0.8% |
| 86562m | 48 | 0.8% |
| 713448 | 48 | 0.8% |
| 254687 | 46 | 0.8% |
| Other values (1068) | 5444 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 4144 | |
| 6 | 3671 | |
| 4 | 3667 | |
| 2 | 3651 | |
| 7 | 3402 | |
| 3 | 3332 | |
| 5 | 3327 | |
| 1 | 3264 | |
| 8 | 2996 | |
| 9 | 2467 | |
| Other values (24) | 2601 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 33921 | |
| Uppercase Letter | 2601 | 7.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 227 | 8.7% |
| R | 204 | 7.8% |
| X | 191 | 7.3% |
| V | 175 | 6.7% |
| H | 166 | 6.4% |
| Y | 160 | 6.2% |
| L | 158 | 6.1% |
| M | 136 | 5.2% |
| N | 122 | 4.7% |
| Q | 118 | 4.5% |
| Other values (14) | 944 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 4144 | |
| 6 | 3671 | |
| 4 | 3667 | |
| 2 | 3651 | |
| 7 | 3402 | |
| 3 | 3332 | |
| 5 | 3327 | |
| 1 | 3264 | |
| 8 | 2996 | |
| 9 | 2467 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 33921 | |
| Latin | 2601 | 7.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| P | 227 | 8.7% |
| R | 204 | 7.8% |
| X | 191 | 7.3% |
| V | 175 | 6.7% |
| H | 166 | 6.4% |
| Y | 160 | 6.2% |
| L | 158 | 6.1% |
| M | 136 | 5.2% |
| N | 122 | 4.7% |
| Q | 118 | 4.5% |
| Other values (14) | 944 |
Common
| Value | Count | Frequency (%) |
| 0 | 4144 | |
| 6 | 3671 | |
| 4 | 3667 | |
| 2 | 3651 | |
| 7 | 3402 | |
| 3 | 3332 | |
| 5 | 3327 | |
| 1 | 3264 | |
| 8 | 2996 | |
| 9 | 2467 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 36522 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 4144 | |
| 6 | 3671 | |
| 4 | 3667 | |
| 2 | 3651 | |
| 7 | 3402 | |
| 3 | 3332 | |
| 5 | 3327 | |
| 1 | 3264 | |
| 8 | 2996 | |
| 9 | 2467 | |
| Other values (24) | 2601 |
issue_cusip
Categorical
| Distinct | 1471 |
|---|---|
| Distinct (%) | 24.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 95.1 KiB |
| AD3 | 26 |
|---|---|
| AF2 | 24 |
| AC4 | 24 |
| AC5 | 24 |
| AA1 | 23 |
| Other values (1466) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 18261 |
|---|---|
| Distinct characters | 34 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 683 ? |
|---|---|
| Unique (%) | 11.2% |
Sample
| 1st row | BB7 |
|---|---|
| 2nd row | AJ4 |
| 3rd row | AB6 |
| 4th row | BC5 |
| 5th row | AH5 |
Common Values
| Value | Count | Frequency (%) |
| AD3 | 26 | 0.4% |
| AF2 | 24 | 0.4% |
| AC4 | 24 | 0.4% |
| AC5 | 24 | 0.4% |
| AA1 | 23 | 0.4% |
| AJ4 | 23 | 0.4% |
| AA0 | 23 | 0.4% |
| AA7 | 23 | 0.4% |
| AF9 | 23 | 0.4% |
| AP4 | 22 | 0.4% |
| Other values (1461) | 5852 |
Length
| Value | Count | Frequency (%) |
| ad3 | 26 | 0.4% |
| ac4 | 24 | 0.4% |
| ac5 | 24 | 0.4% |
| af2 | 24 | 0.4% |
| aa1 | 23 | 0.4% |
| aj4 | 23 | 0.4% |
| aa0 | 23 | 0.4% |
| aa7 | 23 | 0.4% |
| af9 | 23 | 0.4% |
| aa3 | 22 | 0.4% |
| Other values (1461) | 5852 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 3667 | |
| B | 1565 | 8.6% |
| C | 848 | 4.6% |
| 2 | 631 | 3.5% |
| 3 | 626 | 3.4% |
| 4 | 623 | 3.4% |
| 9 | 622 | 3.4% |
| 1 | 621 | 3.4% |
| 5 | 618 | 3.4% |
| 7 | 614 | 3.4% |
| Other values (24) | 7826 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 12137 | |
| Decimal Number | 6124 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 3667 | |
| B | 1565 | |
| C | 848 | 7.0% |
| D | 594 | 4.9% |
| E | 459 | 3.8% |
| F | 390 | 3.2% |
| G | 379 | 3.1% |
| J | 378 | 3.1% |
| H | 374 | 3.1% |
| L | 309 | 2.5% |
| Other values (14) | 3174 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 631 | |
| 3 | 626 | |
| 4 | 623 | |
| 9 | 622 | |
| 1 | 621 | |
| 5 | 618 | |
| 7 | 614 | |
| 8 | 597 | |
| 0 | 595 | |
| 6 | 577 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 12137 | |
| Common | 6124 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 3667 | |
| B | 1565 | |
| C | 848 | 7.0% |
| D | 594 | 4.9% |
| E | 459 | 3.8% |
| F | 390 | 3.2% |
| G | 379 | 3.1% |
| J | 378 | 3.1% |
| H | 374 | 3.1% |
| L | 309 | 2.5% |
| Other values (14) | 3174 |
Common
| Value | Count | Frequency (%) |
| 2 | 631 | |
| 3 | 626 | |
| 4 | 623 | |
| 9 | 622 | |
| 1 | 621 | |
| 5 | 618 | |
| 7 | 614 | |
| 8 | 597 | |
| 0 | 595 | |
| 6 | 577 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 18261 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 3667 | |
| B | 1565 | 8.6% |
| C | 848 | 4.6% |
| 2 | 631 | 3.5% |
| 3 | 626 | 3.4% |
| 4 | 623 | 3.4% |
| 9 | 622 | 3.4% |
| 1 | 621 | 3.4% |
| 5 | 618 | 3.4% |
| 7 | 614 | 3.4% |
| Other values (24) | 7826 |
issue_name
Categorical
HIGH CARDINALITY  IMBALANCE 
| Distinct | 227 |
|---|---|
| Distinct (%) | 3.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 95.1 KiB |
| GLOBAL SR NT | |
|---|---|
| GLOBAL NT | |
| GLOBAL GTD SR NT | |
| GLOBAL GTD NT | |
| GLOBAL SR NT FLTG RT | 208 |
| Other values (222) |
Length
| Max length | 47 |
|---|---|
| Median length | 44 |
| Mean length | 13.650731 |
| Min length | 2 |
Characters and Unicode
| Total characters | 83092 |
|---|---|
| Distinct characters | 39 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 149 ? |
|---|---|
| Unique (%) | 2.4% |
Sample
| 1st row | GLOBAL NT |
|---|---|
| 2nd row | GLOBAL SR NT |
| 3rd row | GLOBAL SR NT |
| 4th row | GLOBAL NT |
| 5th row | GLOBAL SR NT |
Common Values
| Value | Count | Frequency (%) |
| GLOBAL SR NT | 2414 | |
| GLOBAL NT | 1283 | |
| GLOBAL GTD SR NT | 834 | 13.7% |
| GLOBAL GTD NT | 359 | 5.9% |
| GLOBAL SR NT FLTG RT | 208 | 3.4% |
| GLOBAL NT FLTG RT | 172 | 2.8% |
| GLOBAL SR NT FIXED/FLTG RT | 108 | 1.8% |
| GLOBAL NT FIXED/FLTG RT | 53 | 0.9% |
| GLOBAL 1ST MTG BD | 50 | 0.8% |
| GLOBAL SUB NT FIXED/FLTG RT | 47 | 0.8% |
| Other values (217) | 559 | 9.2% |
Length
| Value | Count | Frequency (%) |
| global | 6051 | |
| nt | 5910 | |
| sr | 3837 | |
| gtd | 1381 | 7.0% |
| rt | 759 | 3.8% |
| fltg | 533 | 2.7% |
| fixed/fltg | 222 | 1.1% |
| ser | 167 | 0.8% |
| bd | 129 | 0.7% |
| sub | 122 | 0.6% |
| Other values (135) | 712 | 3.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| 13736 | ||
| L | 12911 | |
| T | 9080 | |
| G | 8318 | |
| B | 6392 | |
| A | 6150 | |
| O | 6092 | |
| N | 5973 | |
| R | 4843 | 5.8% |
| S | 4303 | 5.2% |
| Other values (29) | 5294 | 6.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 68677 | |
| Space Separator | 13736 | 16.5% |
| Decimal Number | 387 | 0.5% |
| Other Punctuation | 284 | 0.3% |
| Dash Punctuation | 8 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| L | 12911 | |
| T | 9080 | |
| G | 8318 | |
| B | 6392 | |
| A | 6150 | |
| O | 6092 | |
| N | 5973 | |
| R | 4843 | 7.1% |
| S | 4303 | 6.3% |
| D | 1899 | 2.8% |
| Other values (16) | 2716 | 4.0% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 158 | |
| 2 | 114 | |
| 0 | 74 | |
| 8 | 14 | 3.6% |
| 7 | 9 | 2.3% |
| 9 | 6 | 1.6% |
| 5 | 5 | 1.3% |
| 3 | 4 | 1.0% |
| 6 | 3 | 0.8% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 258 | |
| & | 26 | 9.2% |
Space Separator
| Value | Count | Frequency (%) |
| 13736 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 8 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 68677 | |
| Common | 14415 | 17.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| L | 12911 | |
| T | 9080 | |
| G | 8318 | |
| B | 6392 | |
| A | 6150 | |
| O | 6092 | |
| N | 5973 | |
| R | 4843 | 7.1% |
| S | 4303 | 6.3% |
| D | 1899 | 2.8% |
| Other values (16) | 2716 | 4.0% |
Common
| Value | Count | Frequency (%) |
| 13736 | ||
| / | 258 | 1.8% |
| 1 | 158 | 1.1% |
| 2 | 114 | 0.8% |
| 0 | 74 | 0.5% |
| & | 26 | 0.2% |
| 8 | 14 | 0.1% |
| 7 | 9 | 0.1% |
| - | 8 | 0.1% |
| 9 | 6 | < 0.1% |
| Other values (3) | 12 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 83092 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 13736 | ||
| L | 12911 | |
| T | 9080 | |
| G | 8318 | |
| B | 6392 | |
| A | 6150 | |
| O | 6092 | |
| N | 5973 | |
| R | 4843 | 5.8% |
| S | 4303 | 5.2% |
| Other values (29) | 5294 | 6.4% |
maturity
Date
| Distinct | 2340 |
|---|---|
| Distinct (%) | 38.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 95.1 KiB |
| Minimum | 2013-09-13 00:00:00 |
|---|---|
| Maximum | 2052-05-01 00:00:00 |
security_level
Categorical
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 6 |
| Missing (%) | 0.1% |
| Memory size | 95.1 KiB |
| SEN | |
|---|---|
| SS | 122 |
| SUB | 104 |
| SENS | 9 |
| JUNS | 6 |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 2.9824042 |
| Min length | 2 |
Characters and Unicode
| Total characters | 18136 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | SEN |
|---|---|
| 2nd row | SEN |
| 3rd row | SEN |
| 4th row | SEN |
| 5th row | SEN |
Common Values
| Value | Count | Frequency (%) |
| SEN | 5839 | |
| SS | 122 | 2.0% |
| SUB | 104 | 1.7% |
| SENS | 9 | 0.1% |
| JUNS | 6 | 0.1% |
| NON | 1 | < 0.1% |
| (Missing) | 6 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| sen | 5839 | |
| ss | 122 | 2.0% |
| sub | 104 | 1.7% |
| sens | 9 | 0.1% |
| juns | 6 | 0.1% |
| non | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 6211 | |
| N | 5856 | |
| E | 5848 | |
| U | 110 | 0.6% |
| B | 104 | 0.6% |
| J | 6 | < 0.1% |
| O | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 18136 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 6211 | |
| N | 5856 | |
| E | 5848 | |
| U | 110 | 0.6% |
| B | 104 | 0.6% |
| J | 6 | < 0.1% |
| O | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 18136 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 6211 | |
| N | 5856 | |
| E | 5848 | |
| U | 110 | 0.6% |
| B | 104 | 0.6% |
| J | 6 | < 0.1% |
| O | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 18136 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 6211 | |
| N | 5856 | |
| E | 5848 | |
| U | 110 | 0.6% |
| B | 104 | 0.6% |
| J | 6 | < 0.1% |
| O | 1 | < 0.1% |
enhancement
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.5 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 4696 | |
| True | 1391 | 22.9% |
coupon_type
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 95.1 KiB |
| F | |
|---|---|
| V |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 6086 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | F |
|---|---|
| 2nd row | F |
| 3rd row | F |
| 4th row | F |
| 5th row | F |
Common Values
| Value | Count | Frequency (%) |
| F | 5314 | |
| V | 772 | 12.7% |
| (Missing) | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| f | 5314 | |
| v | 772 | 12.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| F | 5314 | |
| V | 772 | 12.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 6086 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 5314 | |
| V | 772 | 12.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 6086 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| F | 5314 | |
| V | 772 | 12.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6086 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| F | 5314 | |
| V | 772 | 12.7% |
mtn
Boolean
HIGH CORRELATION  IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.5 KiB |
| False | |
|---|---|
| True | 2 |
| Value | Count | Frequency (%) |
| False | 6085 | |
| True | 2 | < 0.1% |
asset_backed
Boolean
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.5 KiB |
| False |
|---|
| Value | Count | Frequency (%) |
| False | 6087 |
yankee
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.5 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 5139 | |
| True | 948 | 15.6% |
canadian
Boolean
HIGH CORRELATION  IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.5 KiB |
| False | |
|---|---|
| True | 120 |
| Value | Count | Frequency (%) |
| False | 5967 | |
| True | 120 | 2.0% |
oid
Boolean
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.5 KiB |
| False |
|---|
| Value | Count | Frequency (%) |
| False | 6087 |
slob
Boolean
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.5 KiB |
| False |
|---|
| Value | Count | Frequency (%) |
| False | 6087 |
issue_offered_global
Boolean
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.5 KiB |
| True |
|---|
| Value | Count | Frequency (%) |
| True | 6087 |
settlement_type
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 95.1 KiB |
| S | |
|---|---|
| N | 6 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 6087 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | S |
|---|---|
| 2nd row | S |
| 3rd row | S |
| 4th row | S |
| 5th row | S |
Common Values
| Value | Count | Frequency (%) |
| S | 6081 | |
| N | 6 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| s | 6081 | |
| n | 6 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 6081 | |
| N | 6 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 6087 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 6081 | |
| N | 6 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 6087 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 6081 | |
| N | 6 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6087 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 6081 | |
| N | 6 | 0.1% |
gross_spread
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 137 |
|---|---|
| Distinct (%) | 2.4% |
| Missing | 348 |
| Missing (%) | 5.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.020101 |
| Minimum | 0.35 |
|---|---|
| Maximum | 30 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 95.1 KiB |
Quantile statistics
| Minimum | 0.35 |
|---|---|
| 5-th percentile | 1.5 |
| Q1 | 3.5 |
| median | 4.5 |
| Q3 | 6.5 |
| 95-th percentile | 8.75 |
| Maximum | 30 |
| Range | 29.65 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.619326 |
|---|---|
| Coefficient of variation (CV) | 0.52176759 |
| Kurtosis | 7.1586594 |
| Mean | 5.020101 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 1.7130547 |
| Sum | 28810.36 |
| Variance | 6.8608687 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6.5 | 1359 | |
| 4.5 | 688 | |
| 3.5 | 647 | |
| 6 | 498 | 8.2% |
| 2.5 | 463 | 7.6% |
| 4 | 285 | 4.7% |
| 3 | 174 | 2.9% |
| 2 | 173 | 2.8% |
| 6.25 | 169 | 2.8% |
| 1.5 | 149 | 2.4% |
| Other values (127) | 1134 | |
| (Missing) | 348 | 5.7% |
| Value | Count | Frequency (%) |
| 0.35 | 2 | < 0.1% |
| 0.4 | 1 | < 0.1% |
| 0.5 | 5 | 0.1% |
| 0.6 | 1 | < 0.1% |
| 0.65 | 1 | < 0.1% |
| 0.7 | 1 | < 0.1% |
| 0.75 | 5 | 0.1% |
| 0.8 | 11 | 0.2% |
| 0.9 | 1 | < 0.1% |
| 1 | 77 |
| Value | Count | Frequency (%) |
| 30 | 1 | < 0.1% |
| 28.333 | 1 | < 0.1% |
| 22.5 | 2 | < 0.1% |
| 20 | 7 | |
| 19.6 | 1 | < 0.1% |
| 19.53 | 1 | < 0.1% |
| 19 | 1 | < 0.1% |
| 18.4 | 1 | < 0.1% |
| 17.927 | 1 | < 0.1% |
| 17.86 | 1 | < 0.1% |
selling_concession
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 94 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 1206 |
| Missing (%) | 19.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.9216462 |
| Minimum | 0.08 |
|---|---|
| Maximum | 28.333 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 95.1 KiB |
Quantile statistics
| Minimum | 0.08 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 4.5 |
| Maximum | 28.333 |
| Range | 28.253 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.3039729 |
|---|---|
| Coefficient of variation (CV) | 0.44631446 |
| Kurtosis | 33.519418 |
| Mean | 2.9216462 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.0589071 |
| Sum | 14260.555 |
| Variance | 1.7003454 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 1247 | |
| 2 | 613 | |
| 2.5 | 516 | |
| 3.5 | 444 | 7.3% |
| 1.5 | 416 | 6.8% |
| 3 | 244 | 4.0% |
| 3.75 | 190 | 3.1% |
| 1 | 177 | 2.9% |
| 5 | 118 | 1.9% |
| 4.5 | 81 | 1.3% |
| Other values (84) | 835 | |
| (Missing) | 1206 |
| Value | Count | Frequency (%) |
| 0.08 | 1 | < 0.1% |
| 0.2 | 2 | < 0.1% |
| 0.25 | 1 | < 0.1% |
| 0.3 | 4 | 0.1% |
| 0.35 | 1 | < 0.1% |
| 0.4 | 3 | < 0.1% |
| 0.45 | 5 | 0.1% |
| 0.48 | 5 | 0.1% |
| 0.5 | 16 | 0.3% |
| 0.6 | 57 |
| Value | Count | Frequency (%) |
| 28.333 | 1 | < 0.1% |
| 18 | 1 | < 0.1% |
| 12.533 | 1 | < 0.1% |
| 10 | 3 | |
| 9 | 2 | < 0.1% |
| 8.75 | 1 | < 0.1% |
| 8.25 | 1 | < 0.1% |
| 7.5 | 6 | |
| 7 | 5 | |
| 6.75 | 4 |
comp_neg_exch_deal
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 95.1 KiB |
| NEG | |
|---|---|
| EXCH | 300 |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.0492854 |
| Min length | 3 |
Characters and Unicode
| Total characters | 18561 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | NEG |
|---|---|
| 2nd row | NEG |
| 3rd row | NEG |
| 4th row | NEG |
| 5th row | NEG |
Common Values
| Value | Count | Frequency (%) |
| NEG | 5787 | |
| EXCH | 300 | 4.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| neg | 5787 | |
| exch | 300 | 4.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 6087 | |
| N | 5787 | |
| G | 5787 | |
| X | 300 | 1.6% |
| C | 300 | 1.6% |
| H | 300 | 1.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 18561 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 6087 | |
| N | 5787 | |
| G | 5787 | |
| X | 300 | 1.6% |
| C | 300 | 1.6% |
| H | 300 | 1.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 18561 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 6087 | |
| N | 5787 | |
| G | 5787 | |
| X | 300 | 1.6% |
| C | 300 | 1.6% |
| H | 300 | 1.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 18561 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 6087 | |
| N | 5787 | |
| G | 5787 | |
| X | 300 | 1.6% |
| C | 300 | 1.6% |
| H | 300 | 1.6% |
rule_415_reg
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.5 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 3675 | |
| False | 2412 |
sec_reg_type1
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 32 |
| Missing (%) | 0.5% |
| Memory size | 95.1 KiB |
| S-3 | |
|---|---|
| RBNA | |
| F-3 | |
| S-4 | 230 |
| F-4 | 38 |
| Other values (7) | 56 |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.4351775 |
| Min length | 2 |
Characters and Unicode
| Total characters | 20800 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | RBNA |
|---|---|
| 2nd row | RBNA |
| 3rd row | S-3 |
| 4th row | RBNA |
| 5th row | RBNA |
Common Values
| Value | Count | Frequency (%) |
| S-3 | 2637 | |
| RBNA | 2611 | |
| F-3 | 483 | 7.9% |
| S-4 | 230 | 3.8% |
| F-4 | 38 | 0.6% |
| F-10 | 28 | 0.5% |
| F-6 | 9 | 0.1% |
| F-9 | 7 | 0.1% |
| S-1 | 5 | 0.1% |
| NR | 4 | 0.1% |
| Other values (2) | 3 | < 0.1% |
| (Missing) | 32 | 0.5% |
Length
| Value | Count | Frequency (%) |
| s-3 | 2637 | |
| rbna | 2611 | |
| f-3 | 483 | 8.0% |
| s-4 | 230 | 3.8% |
| f-4 | 38 | 0.6% |
| f-10 | 28 | 0.5% |
| f-6 | 9 | 0.1% |
| f-9 | 7 | 0.1% |
| s-1 | 5 | 0.1% |
| nr | 4 | 0.1% |
| Other values (2) | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 3440 | |
| 3 | 3120 | |
| S | 2875 | |
| R | 2615 | |
| N | 2615 | |
| B | 2611 | |
| A | 2611 | |
| F | 565 | 2.7% |
| 4 | 268 | 1.3% |
| 1 | 33 | 0.2% |
| Other values (5) | 47 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 13892 | |
| Decimal Number | 3468 | 16.7% |
| Dash Punctuation | 3440 | 16.5% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 3120 | |
| 4 | 268 | 7.7% |
| 1 | 33 | 1.0% |
| 0 | 28 | 0.8% |
| 6 | 9 | 0.3% |
| 9 | 7 | 0.2% |
| 2 | 2 | 0.1% |
| 8 | 1 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 2875 | |
| R | 2615 | |
| N | 2615 | |
| B | 2611 | |
| A | 2611 | |
| F | 565 | 4.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 3440 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 13892 | |
| Common | 6908 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| - | 3440 | |
| 3 | 3120 | |
| 4 | 268 | 3.9% |
| 1 | 33 | 0.5% |
| 0 | 28 | 0.4% |
| 6 | 9 | 0.1% |
| 9 | 7 | 0.1% |
| 2 | 2 | < 0.1% |
| 8 | 1 | < 0.1% |
Latin
| Value | Count | Frequency (%) |
| S | 2875 | |
| R | 2615 | |
| N | 2615 | |
| B | 2611 | |
| A | 2611 | |
| F | 565 | 4.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 20800 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| - | 3440 | |
| 3 | 3120 | |
| S | 2875 | |
| R | 2615 | |
| N | 2615 | |
| B | 2611 | |
| A | 2611 | |
| F | 565 | 2.7% |
| 4 | 268 | 1.3% |
| 1 | 33 | 0.2% |
| Other values (5) | 47 | 0.2% |
offering_amt
Real number (ℝ)
| Distinct | 375 |
|---|---|
| Distinct (%) | 6.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 878446.4 |
| Minimum | 379 |
|---|---|
| Maximum | 11000000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 95.1 KiB |
Quantile statistics
| Minimum | 379 |
|---|---|
| 5-th percentile | 300000 |
| Q1 | 500000 |
| median | 700000 |
| Q3 | 1000000 |
| 95-th percentile | 2000000 |
| Maximum | 11000000 |
| Range | 10999621 |
| Interquartile range (IQR) | 500000 |
Descriptive statistics
| Standard deviation | 693083.78 |
|---|---|
| Coefficient of variation (CV) | 0.78898812 |
| Kurtosis | 29.806007 |
| Mean | 878446.4 |
| Median Absolute Deviation (MAD) | 300000 |
| Skewness | 3.733875 |
| Sum | 5.3471032 × 109 |
| Variance | 4.8036512 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 500000 | 959 | |
| 1000000 | 720 | 11.8% |
| 750000 | 571 | 9.4% |
| 400000 | 364 | 6.0% |
| 1250000 | 328 | 5.4% |
| 300000 | 316 | 5.2% |
| 600000 | 305 | 5.0% |
| 1500000 | 294 | 4.8% |
| 350000 | 197 | 3.2% |
| 250000 | 167 | 2.7% |
| Other values (365) | 1866 |
| Value | Count | Frequency (%) |
| 379 | 1 | |
| 727 | 1 | |
| 8040 | 1 | |
| 11000 | 1 | |
| 13811 | 1 | |
| 21000 | 1 | |
| 21270 | 1 | |
| 27250 | 1 | |
| 29802 | 1 | |
| 30000 | 1 |
| Value | Count | Frequency (%) |
| 11000000 | 2 | < 0.1% |
| 9518964 | 1 | < 0.1% |
| 9000000 | 1 | < 0.1% |
| 7500000 | 1 | < 0.1% |
| 6000000 | 4 | |
| 5500000 | 2 | < 0.1% |
| 5400614 | 1 | < 0.1% |
| 5341555 | 1 | < 0.1% |
| 5000000 | 7 | |
| 4750000 | 1 | < 0.1% |
offering_date
Date
| Distinct | 1513 |
|---|---|
| Distinct (%) | 24.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 95.1 KiB |
| Minimum | 2012-02-08 00:00:00 |
|---|---|
| Maximum | 2022-06-28 00:00:00 |
offering_price
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 1049 |
|---|---|
| Distinct (%) | 17.5% |
| Missing | 100 |
| Missing (%) | 1.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 96.36492 |
| Minimum | 0 |
|---|---|
| Maximum | 110.146 |
| Zeros | 204 |
| Zeros (%) | 3.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 95.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 98.684 |
| Q1 | 99.644 |
| median | 99.861 |
| Q3 | 99.992 |
| 95-th percentile | 100 |
| Maximum | 110.146 |
| Range | 110.146 |
| Interquartile range (IQR) | 0.348 |
Descriptive statistics
| Standard deviation | 18.105223 |
|---|---|
| Coefficient of variation (CV) | 0.18788189 |
| Kurtosis | 24.377046 |
| Mean | 96.36492 |
| Median Absolute Deviation (MAD) | 0.139 |
| Skewness | -5.1335679 |
| Sum | 576936.78 |
| Variance | 327.79911 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 100 | 1398 | 23.0% |
| 0 | 204 | 3.4% |
| 99.994 | 25 | 0.4% |
| 99.991 | 24 | 0.4% |
| 99.929 | 21 | 0.3% |
| 99.99 | 20 | 0.3% |
| 99.982 | 20 | 0.3% |
| 99.83 | 19 | 0.3% |
| 99.981 | 19 | 0.3% |
| 99.912 | 18 | 0.3% |
| Other values (1039) | 4219 | |
| (Missing) | 100 | 1.6% |
| Value | Count | Frequency (%) |
| 0 | 204 | |
| 90 | 1 | < 0.1% |
| 95.273 | 1 | < 0.1% |
| 95.291 | 1 | < 0.1% |
| 95.304 | 1 | < 0.1% |
| 95.444 | 1 | < 0.1% |
| 95.83 | 1 | < 0.1% |
| 97.052 | 1 | < 0.1% |
| 97.084 | 1 | < 0.1% |
| 97.09 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 110.146 | 1 | |
| 106.94884 | 1 | |
| 104.688 | 1 | |
| 102.776 | 1 | |
| 102.002 | 1 | |
| 101.414 | 1 | |
| 101.1867 | 1 | |
| 100.763 | 1 | |
| 100.63342 | 1 | |
| 100.5119 | 1 |
offering_yield
Real number (ℝ)
HIGH CORRELATION  MISSING  SKEWED 
| Distinct | 4485 |
|---|---|
| Distinct (%) | 89.2% |
| Missing | 1058 |
| Missing (%) | 17.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 351.93157 |
| Minimum | 0.25702 |
|---|---|
| Maximum | 1750000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 95.1 KiB |
Quantile statistics
| Minimum | 0.25702 |
|---|---|
| 5-th percentile | 1.182478 |
| Q1 | 2.302 |
| median | 3.13045 |
| Q3 | 3.91189 |
| 95-th percentile | 5.25 |
| Maximum | 1750000 |
| Range | 1749999.7 |
| Interquartile range (IQR) | 1.60989 |
Descriptive statistics
| Standard deviation | 24677.283 |
|---|---|
| Coefficient of variation (CV) | 70.11955 |
| Kurtosis | 5028.9495 |
| Mean | 351.93157 |
| Median Absolute Deviation (MAD) | 0.80455 |
| Skewness | 70.914909 |
| Sum | 1769863.8 |
| Variance | 6.0896829 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5.375 | 17 | 0.3% |
| 5 | 15 | 0.2% |
| 5.25 | 14 | 0.2% |
| 5.125 | 13 | 0.2% |
| 5.875 | 13 | 0.2% |
| 4.75 | 13 | 0.2% |
| 5.75 | 12 | 0.2% |
| 5.5 | 10 | 0.2% |
| 5.625 | 10 | 0.2% |
| 4.25 | 9 | 0.1% |
| Other values (4475) | 4903 | |
| (Missing) | 1058 | 17.4% |
| Value | Count | Frequency (%) |
| 0.25702 | 1 | |
| 0.309 | 1 | |
| 0.333 | 1 | |
| 0.34482 | 1 | |
| 0.36387 | 1 | |
| 0.37418 | 1 | |
| 0.3878 | 1 | |
| 0.40085 | 1 | |
| 0.418 | 1 | |
| 0.41914 | 1 |
| Value | Count | Frequency (%) |
| 1750000 | 1 | |
| 3924 | 1 | |
| 15 | 1 | |
| 12.5 | 1 | |
| 12.0962 | 1 | |
| 10.37761 | 1 | |
| 10.125 | 1 | |
| 9.99964 | 1 | |
| 9.99465 | 1 | |
| 9.75 | 1 |
delivery_date
Categorical
| Distinct | 1744 |
|---|---|
| Distinct (%) | 28.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 95.1 KiB |
| 2019-11-25 | 35 |
|---|---|
| 2019-06-03 | 24 |
| 2019-09-16 | 21 |
| 2018-11-26 | 19 |
| 2020-03-25 | 18 |
| Other values (1739) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 60870 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 465 ? |
|---|---|
| Unique (%) | 7.6% |
Sample
| 1st row | 2012-02-13 |
|---|---|
| 2nd row | 2012-02-13 |
| 3rd row | 2012-02-13 |
| 4th row | 2012-02-13 |
| 5th row | 2012-02-10 |
Common Values
| Value | Count | Frequency (%) |
| 2019-11-25 | 35 | 0.6% |
| 2019-06-03 | 24 | 0.4% |
| 2019-09-16 | 21 | 0.3% |
| 2018-11-26 | 19 | 0.3% |
| 2020-03-25 | 18 | 0.3% |
| 2017-05-11 | 18 | 0.3% |
| 2020-05-18 | 16 | 0.3% |
| 2018-12-13 | 16 | 0.3% |
| 2020-03-27 | 15 | 0.2% |
| 2015-03-12 | 15 | 0.2% |
| Other values (1734) | 5890 |
Length
| Value | Count | Frequency (%) |
| 2019-11-25 | 35 | 0.6% |
| 2019-06-03 | 24 | 0.4% |
| 2019-09-16 | 21 | 0.3% |
| 2018-11-26 | 19 | 0.3% |
| 2020-03-25 | 18 | 0.3% |
| 2017-05-11 | 18 | 0.3% |
| 2020-05-18 | 16 | 0.3% |
| 2018-12-13 | 16 | 0.3% |
| 2020-03-27 | 15 | 0.2% |
| 2015-03-12 | 15 | 0.2% |
| Other values (1734) | 5890 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 14417 | |
| - | 12174 | |
| 2 | 11793 | |
| 1 | 10340 | |
| 3 | 2197 | 3.6% |
| 5 | 1833 | 3.0% |
| 9 | 1793 | 2.9% |
| 8 | 1757 | 2.9% |
| 6 | 1655 | 2.7% |
| 7 | 1472 | 2.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 48696 | |
| Dash Punctuation | 12174 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 14417 | |
| 2 | 11793 | |
| 1 | 10340 | |
| 3 | 2197 | 4.5% |
| 5 | 1833 | 3.8% |
| 9 | 1793 | 3.7% |
| 8 | 1757 | 3.6% |
| 6 | 1655 | 3.4% |
| 7 | 1472 | 3.0% |
| 4 | 1439 | 3.0% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 12174 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 60870 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 14417 | |
| - | 12174 | |
| 2 | 11793 | |
| 1 | 10340 | |
| 3 | 2197 | 3.6% |
| 5 | 1833 | 3.0% |
| 9 | 1793 | 2.9% |
| 8 | 1757 | 2.9% |
| 6 | 1655 | 2.7% |
| 7 | 1472 | 2.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 60870 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 14417 | |
| - | 12174 | |
| 2 | 11793 | |
| 1 | 10340 | |
| 3 | 2197 | 3.6% |
| 5 | 1833 | 3.0% |
| 9 | 1793 | 2.9% |
| 8 | 1757 | 2.9% |
| 6 | 1655 | 2.7% |
| 7 | 1472 | 2.4% |
unit_deal
Boolean
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.5 KiB |
| False |
|---|
| Value | Count | Frequency (%) |
| False | 6087 |
form_of_own
Categorical
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 95.1 KiB |
| BE |
|---|
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 12174 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BE |
|---|---|
| 2nd row | BE |
| 3rd row | BE |
| 4th row | BE |
| 5th row | BE |
Common Values
| Value | Count | Frequency (%) |
| BE | 6087 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| be | 6087 |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 6087 | |
| E | 6087 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 12174 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 6087 | |
| E | 6087 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 12174 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| B | 6087 | |
| E | 6087 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 12174 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| B | 6087 | |
| E | 6087 |
denomination
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 13 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 95.1 KiB |
| 2/1 | |
|---|---|
| 1/1 | |
| 200/1 | 433 |
| 100/1 | 95 |
| 150/1 | 36 |
| Other values (8) | 32 |
Length
| Max length | 8 |
|---|---|
| Median length | 3 |
| Mean length | 3.1920486 |
| Min length | 3 |
Characters and Unicode
| Total characters | 19430 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 2/1 |
|---|---|
| 2nd row | 2/1 |
| 3rd row | 2/1 |
| 4th row | 2/1 |
| 5th row | 2/1 |
Common Values
| Value | Count | Frequency (%) |
| 2/1 | 4883 | |
| 1/1 | 608 | 10.0% |
| 200/1 | 433 | 7.1% |
| 100/1 | 95 | 1.6% |
| 150/1 | 36 | 0.6% |
| 5/1 | 12 | 0.2% |
| 250/1 | 11 | 0.2% |
| 200/2 | 3 | < 0.1% |
| 75/1 | 2 | < 0.1% |
| 10/1 | 1 | < 0.1% |
| Other values (3) | 3 | < 0.1% |
Length
| Value | Count | Frequency (%) |
| 2/1 | 4883 | |
| 1/1 | 608 | 10.0% |
| 200/1 | 433 | 7.1% |
| 100/1 | 95 | 1.6% |
| 150/1 | 36 | 0.6% |
| 5/1 | 12 | 0.2% |
| 250/1 | 11 | 0.2% |
| 200/2 | 3 | < 0.1% |
| 75/1 | 2 | < 0.1% |
| 10/1 | 1 | < 0.1% |
| Other values (3) | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 6824 | |
| / | 6087 | |
| 2 | 5334 | |
| 0 | 1119 | 5.8% |
| 5 | 64 | 0.3% |
| 7 | 2 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 13343 | |
| Other Punctuation | 6087 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 6824 | |
| 2 | 5334 | |
| 0 | 1119 | 8.4% |
| 5 | 64 | 0.5% |
| 7 | 2 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 6087 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 19430 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 6824 | |
| / | 6087 | |
| 2 | 5334 | |
| 0 | 1119 | 5.8% |
| 5 | 64 | 0.3% |
| 7 | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 19430 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 6824 | |
| / | 6087 | |
| 2 | 5334 | |
| 0 | 1119 | 5.8% |
| 5 | 64 | 0.3% |
| 7 | 2 | < 0.1% |
principal_amt
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1967.1433 |
| Minimum | 0 |
|---|---|
| Maximum | 2000000 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 95.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1000 |
| Q1 | 1000 |
| median | 1000 |
| Q3 | 1000 |
| 95-th percentile | 1000 |
| Maximum | 2000000 |
| Range | 2000000 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 27929.902 |
|---|---|
| Coefficient of variation (CV) | 14.198204 |
| Kurtosis | 4312.2779 |
| Mean | 1967.1433 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 61.277713 |
| Sum | 11974001 |
| Variance | 7.8007943 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1000 | 6060 | |
| 200000 | 18 | 0.3% |
| 150000 | 2 | < 0.1% |
| 2000 | 2 | < 0.1% |
| 5000 | 2 | < 0.1% |
| 1 | 1 | < 0.1% |
| 0 | 1 | < 0.1% |
| 2000000 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
| 1000 | 6060 | |
| 2000 | 2 | < 0.1% |
| 5000 | 2 | < 0.1% |
| 150000 | 2 | < 0.1% |
| 200000 | 18 | 0.3% |
| 2000000 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2000000 | 1 | < 0.1% |
| 200000 | 18 | 0.3% |
| 150000 | 2 | < 0.1% |
| 5000 | 2 | < 0.1% |
| 2000 | 2 | < 0.1% |
| 1000 | 6060 | |
| 1 | 1 | < 0.1% |
| 0 | 1 | < 0.1% |
covenants
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 59.4 KiB |
| True | |
|---|---|
| False | 171 |
| (Missing) | 1 |
| Value | Count | Frequency (%) |
| True | 5915 | |
| False | 171 | 2.8% |
| (Missing) | 1 | < 0.1% |
defeased
Boolean
HIGH CORRELATION  IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.5 KiB |
| False | |
|---|---|
| True | 1 |
| Value | Count | Frequency (%) |
| False | 6086 | |
| True | 1 | < 0.1% |
defaulted
Boolean
HIGH CORRELATION  IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.5 KiB |
| False | |
|---|---|
| True | 1 |
| Value | Count | Frequency (%) |
| False | 6086 | |
| True | 1 | < 0.1% |
tender_exch_offer
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.5 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 5251 | |
| True | 836 | 13.7% |
redeemable
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.5 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 5462 | |
| False | 625 | 10.3% |
refund_protection
Boolean
HIGH CORRELATION  IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.5 KiB |
| False | |
|---|---|
| True | 1 |
| Value | Count | Frequency (%) |
| False | 6086 | |
| True | 1 | < 0.1% |
overallotment_opt
Boolean
HIGH CORRELATION  IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.5 KiB |
| False | |
|---|---|
| True | 3 |
| Value | Count | Frequency (%) |
| False | 6084 | |
| True | 3 | < 0.1% |
announced_call
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.5 KiB |
| False | |
|---|---|
| True | 28 |
| Value | Count | Frequency (%) |
| False | 6059 | |
| True | 28 | 0.5% |
active_issue
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.5 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 4008 | |
| False | 2079 |
dep_eligibility
Categorical
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 95.1 KiB |
| DCE | |
|---|---|
| DTC | 73 |
| EUCD | 21 |
| DCED | 3 |
| DE | 2 |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.0037792 |
| Min length | 2 |
Characters and Unicode
| Total characters | 18281 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | DCE |
|---|---|
| 2nd row | DCE |
| 3rd row | DCE |
| 4th row | DCE |
| 5th row | DCE |
Common Values
| Value | Count | Frequency (%) |
| DCE | 5986 | |
| DTC | 73 | 1.2% |
| EUCD | 21 | 0.3% |
| DCED | 3 | < 0.1% |
| DE | 2 | < 0.1% |
| DFEC | 1 | < 0.1% |
| (Missing) | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| dce | 5986 | |
| dtc | 73 | 1.2% |
| eucd | 21 | 0.3% |
| dced | 3 | < 0.1% |
| de | 2 | < 0.1% |
| dfec | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| D | 6089 | |
| C | 6084 | |
| E | 6013 | |
| T | 73 | 0.4% |
| U | 21 | 0.1% |
| F | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 18281 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 6089 | |
| C | 6084 | |
| E | 6013 | |
| T | 73 | 0.4% |
| U | 21 | 0.1% |
| F | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 18281 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| D | 6089 | |
| C | 6084 | |
| E | 6013 | |
| T | 73 | 0.4% |
| U | 21 | 0.1% |
| F | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 18281 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| D | 6089 | |
| C | 6084 | |
| E | 6013 | |
| T | 73 | 0.4% |
| U | 21 | 0.1% |
| F | 1 | < 0.1% |
bond_type
Categorical
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 95.1 KiB |
| CDEB |
|---|
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 24348 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CDEB |
|---|---|
| 2nd row | CDEB |
| 3rd row | CDEB |
| 4th row | CDEB |
| 5th row | CDEB |
Common Values
| Value | Count | Frequency (%) |
| CDEB | 6087 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| cdeb | 6087 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 6087 | |
| D | 6087 | |
| E | 6087 | |
| B | 6087 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 24348 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 6087 | |
| D | 6087 | |
| E | 6087 | |
| B | 6087 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 24348 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| C | 6087 | |
| D | 6087 | |
| E | 6087 | |
| B | 6087 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 24348 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| C | 6087 | |
| D | 6087 | |
| E | 6087 | |
| B | 6087 |
subsequent_data
Boolean
HIGH CORRELATION  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 2506 |
| Missing (%) | 41.2% |
| Memory size | 59.4 KiB |
| True | |
|---|---|
| False | |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 3181 | |
| False | 400 | 6.6% |
| (Missing) | 2506 |
isin
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 6080 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 7 |
| Missing (%) | 0.1% |
| Memory size | 95.1 KiB |
| US00206RBB78 | 1 |
|---|---|
| US30034WAA45 | 1 |
| US44106MAZ59 | 1 |
| US714046AG46 | 1 |
| US60687YBA64 | 1 |
| Other values (6075) |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 12 |
| Min length | 12 |
Characters and Unicode
| Total characters | 72960 |
|---|---|
| Distinct characters | 34 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 6080 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | US00206RBB78 |
|---|---|
| 2nd row | US87161CAJ45 |
| 3rd row | US055921AB64 |
| 4th row | US00206RBC51 |
| 5th row | US001055AH52 |
Common Values
| Value | Count | Frequency (%) |
| US00206RBB78 | 1 | < 0.1% |
| US30034WAA45 | 1 | < 0.1% |
| US44106MAZ59 | 1 | < 0.1% |
| US714046AG46 | 1 | < 0.1% |
| US60687YBA64 | 1 | < 0.1% |
| US60687YAZ25 | 1 | < 0.1% |
| US60687YBB48 | 1 | < 0.1% |
| US34964CAE66 | 1 | < 0.1% |
| US88947EAU47 | 1 | < 0.1% |
| US72346QAC87 | 1 | < 0.1% |
| Other values (6070) | 6070 | |
| (Missing) | 7 | 0.1% |
Length
| Value | Count | Frequency (%) |
| us00206rbb78 | 1 | < 0.1% |
| us02005nal47 | 1 | < 0.1% |
| us00206rbc51 | 1 | < 0.1% |
| us001055ah52 | 1 | < 0.1% |
| us001055aj19 | 1 | < 0.1% |
| us00206rbd35 | 1 | < 0.1% |
| us489170ac47 | 1 | < 0.1% |
| us35671dav73 | 1 | < 0.1% |
| us35671daw56 | 1 | < 0.1% |
| us35671dau90 | 1 | < 0.1% |
| Other values (6070) | 6070 |
Most occurring characters
| Value | Count | Frequency (%) |
| U | 6360 | 8.7% |
| S | 6326 | 8.7% |
| 0 | 5349 | 7.3% |
| 4 | 4905 | 6.7% |
| 2 | 4879 | 6.7% |
| 6 | 4825 | 6.6% |
| 7 | 4619 | 6.3% |
| 3 | 4568 | 6.3% |
| 5 | 4538 | 6.2% |
| 1 | 4507 | 6.2% |
| Other values (24) | 22084 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 46088 | |
| Uppercase Letter | 26872 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| U | 6360 | |
| S | 6326 | |
| A | 3740 | |
| B | 1647 | 6.1% |
| C | 955 | 3.6% |
| D | 671 | 2.5% |
| E | 543 | 2.0% |
| H | 540 | 2.0% |
| P | 484 | 1.8% |
| L | 465 | 1.7% |
| Other values (14) | 5141 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 5349 | |
| 4 | 4905 | |
| 2 | 4879 | |
| 6 | 4825 | |
| 7 | 4619 | |
| 3 | 4568 | |
| 5 | 4538 | |
| 1 | 4507 | |
| 8 | 4169 | |
| 9 | 3729 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 46088 | |
| Latin | 26872 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| U | 6360 | |
| S | 6326 | |
| A | 3740 | |
| B | 1647 | 6.1% |
| C | 955 | 3.6% |
| D | 671 | 2.5% |
| E | 543 | 2.0% |
| H | 540 | 2.0% |
| P | 484 | 1.8% |
| L | 465 | 1.7% |
| Other values (14) | 5141 |
Common
| Value | Count | Frequency (%) |
| 0 | 5349 | |
| 4 | 4905 | |
| 2 | 4879 | |
| 6 | 4825 | |
| 7 | 4619 | |
| 3 | 4568 | |
| 5 | 4538 | |
| 1 | 4507 | |
| 8 | 4169 | |
| 9 | 3729 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 72960 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| U | 6360 | 8.7% |
| S | 6326 | 8.7% |
| 0 | 5349 | 7.3% |
| 4 | 4905 | 6.7% |
| 2 | 4879 | 6.7% |
| 6 | 4825 | 6.6% |
| 7 | 4619 | 6.3% |
| 3 | 4568 | 6.3% |
| 5 | 4538 | 6.2% |
| 1 | 4507 | 6.2% |
| Other values (24) | 22084 |
fungible
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.5 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 4229 | |
| False | 1858 |
complete_cusip
Categorical
HIGH CARDINALITY  UNIFORM  UNIQUE 
| Distinct | 6087 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 95.1 KiB |
| 00206RBB7 | 1 |
|---|---|
| 46647PBE5 | 1 |
| 714046AG4 | 1 |
| 60687YBA6 | 1 |
| 60687YAZ2 | 1 |
| Other values (6082) |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Characters and Unicode
| Total characters | 54783 |
|---|---|
| Distinct characters | 35 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 6087 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 00206RBB7 |
|---|---|
| 2nd row | 87161CAJ4 |
| 3rd row | 055921AB6 |
| 4th row | 00206RBC5 |
| 5th row | 001055AH5 |
Common Values
| Value | Count | Frequency (%) |
| 00206RBB7 | 1 | < 0.1% |
| 46647PBE5 | 1 | < 0.1% |
| 714046AG4 | 1 | < 0.1% |
| 60687YBA6 | 1 | < 0.1% |
| 60687YAZ2 | 1 | < 0.1% |
| 60687YBB4 | 1 | < 0.1% |
| 34964CAE6 | 1 | < 0.1% |
| 88947EAU4 | 1 | < 0.1% |
| 72346QAC8 | 1 | < 0.1% |
| 30034WAB2 | 1 | < 0.1% |
| Other values (6077) | 6077 |
Length
| Value | Count | Frequency (%) |
| 00206rbb7 | 1 | < 0.1% |
| 02005nal4 | 1 | < 0.1% |
| 00206rbc5 | 1 | < 0.1% |
| 001055ah5 | 1 | < 0.1% |
| 001055aj1 | 1 | < 0.1% |
| 00206rbd3 | 1 | < 0.1% |
| 489170ac4 | 1 | < 0.1% |
| 35671dav7 | 1 | < 0.1% |
| 35671daw5 | 1 | < 0.1% |
| 35671dau9 | 1 | < 0.1% |
| Other values (6077) | 6077 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 4739 | 8.7% |
| 4 | 4290 | 7.8% |
| 2 | 4282 | 7.8% |
| 6 | 4248 | 7.8% |
| 7 | 4016 | 7.3% |
| 3 | 3958 | 7.2% |
| 5 | 3945 | 7.2% |
| 1 | 3885 | 7.1% |
| A | 3744 | 6.8% |
| 8 | 3593 | 6.6% |
| Other values (25) | 14083 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 40045 | |
| Uppercase Letter | 14738 | 26.9% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 3744 | |
| B | 1652 | 11.2% |
| C | 955 | 6.5% |
| D | 671 | 4.6% |
| E | 543 | 3.7% |
| H | 540 | 3.7% |
| P | 484 | 3.3% |
| L | 467 | 3.2% |
| G | 453 | 3.1% |
| F | 451 | 3.1% |
| Other values (15) | 4778 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 4739 | |
| 4 | 4290 | |
| 2 | 4282 | |
| 6 | 4248 | |
| 7 | 4016 | |
| 3 | 3958 | |
| 5 | 3945 | |
| 1 | 3885 | |
| 8 | 3593 | |
| 9 | 3089 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 40045 | |
| Latin | 14738 | 26.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 3744 | |
| B | 1652 | 11.2% |
| C | 955 | 6.5% |
| D | 671 | 4.6% |
| E | 543 | 3.7% |
| H | 540 | 3.7% |
| P | 484 | 3.3% |
| L | 467 | 3.2% |
| G | 453 | 3.1% |
| F | 451 | 3.1% |
| Other values (15) | 4778 |
Common
| Value | Count | Frequency (%) |
| 0 | 4739 | |
| 4 | 4290 | |
| 2 | 4282 | |
| 6 | 4248 | |
| 7 | 4016 | |
| 3 | 3958 | |
| 5 | 3945 | |
| 1 | 3885 | |
| 8 | 3593 | |
| 9 | 3089 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 54783 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 4739 | 8.7% |
| 4 | 4290 | 7.8% |
| 2 | 4282 | 7.8% |
| 6 | 4248 | 7.8% |
| 7 | 4016 | 7.3% |
| 3 | 3958 | 7.2% |
| 5 | 3945 | 7.2% |
| 1 | 3885 | 7.1% |
| A | 3744 | 6.8% |
| 8 | 3593 | 6.6% |
| Other values (25) | 14083 |
action_type
Categorical
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 95.1 KiB |
| I | |
|---|---|
| IM | |
| E | |
| B | 259 |
| T | 259 |
| Other values (7) |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.2640053 |
| Min length | 1 |
Characters and Unicode
| Total characters | 7694 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | E |
|---|---|
| 2nd row | E |
| 3rd row | B |
| 4th row | IM |
| 5th row | IM |
Common Values
| Value | Count | Frequency (%) |
| I | 3417 | |
| IM | 1326 | 21.8% |
| E | 471 | 7.7% |
| B | 259 | 4.3% |
| T | 259 | 4.3% |
| RO | 138 | 2.3% |
| X | 107 | 1.8% |
| REV | 60 | 1.0% |
| P | 20 | 0.3% |
| R | 18 | 0.3% |
| Other values (2) | 12 | 0.2% |
Length
| Value | Count | Frequency (%) |
| i | 3417 | |
| im | 1326 | 21.8% |
| e | 471 | 7.7% |
| b | 259 | 4.3% |
| t | 259 | 4.3% |
| ro | 138 | 2.3% |
| x | 107 | 1.8% |
| rev | 60 | 1.0% |
| p | 20 | 0.3% |
| r | 18 | 0.3% |
| Other values (2) | 12 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| I | 4754 | |
| M | 1326 | 17.2% |
| E | 531 | 6.9% |
| B | 259 | 3.4% |
| T | 259 | 3.4% |
| R | 227 | 3.0% |
| O | 139 | 1.8% |
| X | 107 | 1.4% |
| V | 60 | 0.8% |
| P | 31 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 7694 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 4754 | |
| M | 1326 | 17.2% |
| E | 531 | 6.9% |
| B | 259 | 3.4% |
| T | 259 | 3.4% |
| R | 227 | 3.0% |
| O | 139 | 1.8% |
| X | 107 | 1.4% |
| V | 60 | 0.8% |
| P | 31 | 0.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 7694 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| I | 4754 | |
| M | 1326 | 17.2% |
| E | 531 | 6.9% |
| B | 259 | 3.4% |
| T | 259 | 3.4% |
| R | 227 | 3.0% |
| O | 139 | 1.8% |
| X | 107 | 1.4% |
| V | 60 | 0.8% |
| P | 31 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7694 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| I | 4754 | |
| M | 1326 | 17.2% |
| E | 531 | 6.9% |
| B | 259 | 3.4% |
| T | 259 | 3.4% |
| R | 227 | 3.0% |
| O | 139 | 1.8% |
| X | 107 | 1.4% |
| V | 60 | 0.8% |
| P | 31 | 0.4% |
effective_date
Categorical
| Distinct | 1767 |
|---|---|
| Distinct (%) | 29.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 95.1 KiB |
| 2019-11-25 | 33 |
|---|---|
| 2022-05-20 | 27 |
| 2020-05-11 | 21 |
| 2021-11-08 | 21 |
| 2020-05-07 | 19 |
| Other values (1762) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 60870 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 572 ? |
|---|---|
| Unique (%) | 9.4% |
Sample
| 1st row | 2014-07-15 |
|---|---|
| 2nd row | 2017-11-09 |
| 3rd row | 2018-11-01 |
| 4th row | 2017-02-15 |
| 5th row | 2017-02-15 |
Common Values
| Value | Count | Frequency (%) |
| 2019-11-25 | 33 | 0.5% |
| 2022-05-20 | 27 | 0.4% |
| 2020-05-11 | 21 | 0.3% |
| 2021-11-08 | 21 | 0.3% |
| 2020-05-07 | 19 | 0.3% |
| 2019-09-16 | 19 | 0.3% |
| 2021-03-15 | 18 | 0.3% |
| 2020-03-26 | 17 | 0.3% |
| 2020-08-10 | 17 | 0.3% |
| 2020-03-04 | 17 | 0.3% |
| Other values (1757) | 5878 |
Length
| Value | Count | Frequency (%) |
| 2019-11-25 | 33 | 0.5% |
| 2022-05-20 | 27 | 0.4% |
| 2020-05-11 | 21 | 0.3% |
| 2021-11-08 | 21 | 0.3% |
| 2020-05-07 | 19 | 0.3% |
| 2019-09-16 | 19 | 0.3% |
| 2021-03-15 | 18 | 0.3% |
| 2020-03-26 | 17 | 0.3% |
| 2020-08-10 | 17 | 0.3% |
| 2020-03-04 | 17 | 0.3% |
| Other values (1757) | 5878 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 15050 | |
| 2 | 12827 | |
| - | 12174 | |
| 1 | 9552 | |
| 9 | 2002 | 3.3% |
| 3 | 1808 | 3.0% |
| 5 | 1783 | 2.9% |
| 8 | 1690 | 2.8% |
| 6 | 1402 | 2.3% |
| 7 | 1393 | 2.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 48696 | |
| Dash Punctuation | 12174 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 15050 | |
| 2 | 12827 | |
| 1 | 9552 | |
| 9 | 2002 | 4.1% |
| 3 | 1808 | 3.7% |
| 5 | 1783 | 3.7% |
| 8 | 1690 | 3.5% |
| 6 | 1402 | 2.9% |
| 7 | 1393 | 2.9% |
| 4 | 1189 | 2.4% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 12174 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 60870 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 15050 | |
| 2 | 12827 | |
| - | 12174 | |
| 1 | 9552 | |
| 9 | 2002 | 3.3% |
| 3 | 1808 | 3.0% |
| 5 | 1783 | 2.9% |
| 8 | 1690 | 2.8% |
| 6 | 1402 | 2.3% |
| 7 | 1393 | 2.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 60870 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 15050 | |
| 2 | 12827 | |
| - | 12174 | |
| 1 | 9552 | |
| 9 | 2002 | 3.3% |
| 3 | 1808 | 3.0% |
| 5 | 1783 | 2.9% |
| 8 | 1690 | 2.8% |
| 6 | 1402 | 2.3% |
| 7 | 1393 | 2.3% |
action_price
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 805 |
|---|---|
| Distinct (%) | 73.9% |
| Missing | 4998 |
| Missing (%) | 82.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 103.73529 |
| Minimum | 0 |
|---|---|
| Maximum | 151.556 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 95.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 99.0024 |
| Q1 | 100 |
| median | 102.101 |
| Q3 | 105.616 |
| 95-th percentile | 115.3734 |
| Maximum | 151.556 |
| Range | 151.556 |
| Interquartile range (IQR) | 5.616 |
Descriptive statistics
| Standard deviation | 7.3294175 |
|---|---|
| Coefficient of variation (CV) | 0.070655007 |
| Kurtosis | 45.268332 |
| Mean | 103.73529 |
| Median Absolute Deviation (MAD) | 2.101 |
| Skewness | -1.4471795 |
| Sum | 112967.73 |
| Variance | 53.720361 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 100 | 221 | 3.6% |
| 101 | 27 | 0.4% |
| 102.75 | 5 | 0.1% |
| 97.75 | 3 | < 0.1% |
| 102.875 | 3 | < 0.1% |
| 98 | 3 | < 0.1% |
| 104.253 | 2 | < 0.1% |
| 103.375 | 2 | < 0.1% |
| 100.5 | 2 | < 0.1% |
| 100.854 | 2 | < 0.1% |
| Other values (795) | 819 | 13.5% |
| (Missing) | 4998 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 50.2595 | 1 | |
| 67.1 | 1 | |
| 79.261 | 1 | |
| 79.526 | 1 | |
| 85 | 1 | |
| 89.5 | 2 | |
| 91.688 | 1 | |
| 92.003 | 1 | |
| 92.016 | 1 |
| Value | Count | Frequency (%) |
| 151.556 | 1 | |
| 147.153 | 1 | |
| 143.454 | 1 | |
| 141.172 | 1 | |
| 137.022 | 1 | |
| 136.585 | 1 | |
| 134.35 | 1 | |
| 132.757 | 1 | |
| 131.805 | 1 | |
| 131.638 | 1 |
action_amount
Real number (ℝ)
HIGH CORRELATION  MISSING  SKEWED 
| Distinct | 734 |
|---|---|
| Distinct (%) | 54.7% |
| Missing | 4746 |
| Missing (%) | 78.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 692558.09 |
| Minimum | 0 |
|---|---|
| Maximum | 2.5 × 108 |
| Zeros | 45 |
| Zeros (%) | 0.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 95.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 600.008 |
| Q1 | 172550 |
| median | 400000 |
| Q3 | 694992 |
| 95-th percentile | 1500000 |
| Maximum | 2.5 × 108 |
| Range | 2.5 × 108 |
| Interquartile range (IQR) | 522442 |
Descriptive statistics
| Standard deviation | 6832317.1 |
|---|---|
| Coefficient of variation (CV) | 9.8653343 |
| Kurtosis | 1325.9439 |
| Mean | 692558.09 |
| Median Absolute Deviation (MAD) | 250000 |
| Skewness | 36.312222 |
| Sum | 9.287204 × 108 |
| Variance | 4.6680557 × 1013 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 500000 | 84 | 1.4% |
| 750000 | 53 | 0.9% |
| 1000000 | 50 | 0.8% |
| 300000 | 46 | 0.8% |
| 0 | 45 | 0.7% |
| 400000 | 43 | 0.7% |
| 250000 | 32 | 0.5% |
| 350000 | 27 | 0.4% |
| 1250000 | 26 | 0.4% |
| 600000 | 24 | 0.4% |
| Other values (724) | 911 | 15.0% |
| (Missing) | 4746 |
| Value | Count | Frequency (%) |
| 0 | 45 | |
| 9.744 | 1 | < 0.1% |
| 10 | 1 | < 0.1% |
| 17 | 1 | < 0.1% |
| 20 | 1 | < 0.1% |
| 25 | 1 | < 0.1% |
| 30 | 1 | < 0.1% |
| 102 | 1 | < 0.1% |
| 173 | 1 | < 0.1% |
| 191 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 250000000 | 1 | |
| 5385495 | 1 | |
| 4000000 | 1 | |
| 3843488 | 1 | |
| 3510199 | 1 | |
| 3190096 | 1 | |
| 3175908 | 1 | |
| 3000000 | 1 | |
| 2890467 | 1 | |
| 2850000 | 1 |
amount_outstanding
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 633 |
|---|---|
| Distinct (%) | 10.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 560410.28 |
| Minimum | 0 |
|---|---|
| Maximum | 9518964 |
| Zeros | 2079 |
| Zeros (%) | 34.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 95.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 450000 |
| Q3 | 800000 |
| 95-th percentile | 1850707 |
| Maximum | 9518964 |
| Range | 9518964 |
| Interquartile range (IQR) | 800000 |
Descriptive statistics
| Standard deviation | 672732.7 |
|---|---|
| Coefficient of variation (CV) | 1.2004289 |
| Kurtosis | 10.911483 |
| Mean | 560410.28 |
| Median Absolute Deviation (MAD) | 450000 |
| Skewness | 2.3088767 |
| Sum | 3.4112174 × 109 |
| Variance | 4.5256929 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2079 | |
| 500000 | 559 | 9.2% |
| 1000000 | 427 | 7.0% |
| 750000 | 338 | 5.6% |
| 400000 | 218 | 3.6% |
| 1250000 | 194 | 3.2% |
| 600000 | 192 | 3.2% |
| 1500000 | 186 | 3.1% |
| 300000 | 169 | 2.8% |
| 350000 | 111 | 1.8% |
| Other values (623) | 1614 |
| Value | Count | Frequency (%) |
| 0 | 2079 | |
| 379 | 1 | < 0.1% |
| 632 | 1 | < 0.1% |
| 727 | 1 | < 0.1% |
| 812 | 1 | < 0.1% |
| 1549 | 1 | < 0.1% |
| 2205 | 1 | < 0.1% |
| 2512 | 1 | < 0.1% |
| 2921 | 1 | < 0.1% |
| 3091 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 9518964 | 1 | < 0.1% |
| 5500000 | 2 | < 0.1% |
| 5341555 | 1 | < 0.1% |
| 5000000 | 4 | |
| 4500000 | 1 | < 0.1% |
| 4250000 | 2 | < 0.1% |
| 4000000 | 5 | |
| 3960082 | 1 | < 0.1% |
| 3850000 | 1 | < 0.1% |
| 3797310 | 1 | < 0.1% |
greater_of
Boolean
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 5322 |
| Missing (%) | 87.4% |
| Memory size | 59.4 KiB |
| False | |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) |
| False | 765 | 12.6% |
| (Missing) | 5322 |
lesser_of
Boolean
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 5322 |
| Missing (%) | 87.4% |
| Memory size | 59.4 KiB |
| False | |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) |
| False | 765 | 12.6% |
| (Missing) | 5322 |
see_note
Boolean
HIGH CORRELATION  IMBALANCE  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 5322 |
| Missing (%) | 87.4% |
| Memory size | 59.4 KiB |
| False | |
|---|---|
| True | 1 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 764 | 12.6% |
| True | 1 | < 0.1% |
| (Missing) | 5322 |
dated_date
Categorical
| Distinct | 1761 |
|---|---|
| Distinct (%) | 28.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 95.1 KiB |
| 2017-05-11 | 18 |
|---|---|
| 2020-03-25 | 18 |
| 2019-08-15 | 16 |
| 2020-05-18 | 16 |
| 2019-01-15 | 15 |
| Other values (1756) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 60870 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 469 ? |
|---|---|
| Unique (%) | 7.7% |
Sample
| 1st row | 2012-02-13 |
|---|---|
| 2nd row | 2012-02-13 |
| 3rd row | 2012-02-13 |
| 4th row | 2012-02-13 |
| 5th row | 2012-02-10 |
Common Values
| Value | Count | Frequency (%) |
| 2017-05-11 | 18 | 0.3% |
| 2020-03-25 | 18 | 0.3% |
| 2019-08-15 | 16 | 0.3% |
| 2020-05-18 | 16 | 0.3% |
| 2019-01-15 | 15 | 0.2% |
| 2020-05-11 | 15 | 0.2% |
| 2020-04-01 | 15 | 0.2% |
| 2019-05-15 | 15 | 0.2% |
| 2017-02-09 | 15 | 0.2% |
| 2020-03-27 | 15 | 0.2% |
| Other values (1751) | 5929 |
Length
| Value | Count | Frequency (%) |
| 2017-05-11 | 18 | 0.3% |
| 2020-03-25 | 18 | 0.3% |
| 2019-08-15 | 16 | 0.3% |
| 2020-05-18 | 16 | 0.3% |
| 2019-01-15 | 15 | 0.2% |
| 2020-05-11 | 15 | 0.2% |
| 2020-04-01 | 15 | 0.2% |
| 2019-05-15 | 15 | 0.2% |
| 2017-02-09 | 15 | 0.2% |
| 2020-03-27 | 15 | 0.2% |
| Other values (1751) | 5929 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 14489 | |
| - | 12174 | |
| 2 | 11663 | |
| 1 | 10380 | |
| 3 | 2138 | 3.5% |
| 5 | 1952 | 3.2% |
| 8 | 1773 | 2.9% |
| 9 | 1756 | 2.9% |
| 6 | 1611 | 2.6% |
| 7 | 1480 | 2.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 48696 | |
| Dash Punctuation | 12174 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 14489 | |
| 2 | 11663 | |
| 1 | 10380 | |
| 3 | 2138 | 4.4% |
| 5 | 1952 | 4.0% |
| 8 | 1773 | 3.6% |
| 9 | 1756 | 3.6% |
| 6 | 1611 | 3.3% |
| 7 | 1480 | 3.0% |
| 4 | 1454 | 3.0% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 12174 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 60870 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 14489 | |
| - | 12174 | |
| 2 | 11663 | |
| 1 | 10380 | |
| 3 | 2138 | 3.5% |
| 5 | 1952 | 3.2% |
| 8 | 1773 | 2.9% |
| 9 | 1756 | 2.9% |
| 6 | 1611 | 2.6% |
| 7 | 1480 | 2.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 60870 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 14489 | |
| - | 12174 | |
| 2 | 11663 | |
| 1 | 10380 | |
| 3 | 2138 | 3.5% |
| 5 | 1952 | 3.2% |
| 8 | 1773 | 2.9% |
| 9 | 1756 | 2.9% |
| 6 | 1611 | 2.6% |
| 7 | 1480 | 2.4% |
first_interest_date
Categorical
| Distinct | 1583 |
|---|---|
| Distinct (%) | 26.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 95.1 KiB |
| 2020-10-15 | 49 |
|---|---|
| 2020-12-01 | 45 |
| 2021-02-15 | 42 |
| 2020-11-15 | 41 |
| 2020-11-01 | 39 |
| Other values (1578) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 60870 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 669 ? |
|---|---|
| Unique (%) | 11.0% |
Sample
| 1st row | 2012-08-13 |
|---|---|
| 2nd row | 2012-08-15 |
| 3rd row | 2012-08-15 |
| 4th row | 2012-08-15 |
| 5th row | 2012-08-15 |
Common Values
| Value | Count | Frequency (%) |
| 2020-10-15 | 49 | 0.8% |
| 2020-12-01 | 45 | 0.7% |
| 2021-02-15 | 42 | 0.7% |
| 2020-11-15 | 41 | 0.7% |
| 2020-11-01 | 39 | 0.6% |
| 2020-12-15 | 39 | 0.6% |
| 2021-03-15 | 39 | 0.6% |
| 2020-10-01 | 38 | 0.6% |
| 2020-02-15 | 35 | 0.6% |
| 2022-03-15 | 34 | 0.6% |
| Other values (1573) | 5686 |
Length
| Value | Count | Frequency (%) |
| 2020-10-15 | 49 | 0.8% |
| 2020-12-01 | 45 | 0.7% |
| 2021-02-15 | 42 | 0.7% |
| 2020-11-15 | 41 | 0.7% |
| 2020-11-01 | 39 | 0.6% |
| 2020-12-15 | 39 | 0.6% |
| 2021-03-15 | 39 | 0.6% |
| 2020-10-01 | 38 | 0.6% |
| 2020-02-15 | 35 | 0.6% |
| 2019-09-15 | 34 | 0.6% |
| Other values (1573) | 5686 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 14263 | |
| - | 12174 | |
| 1 | 11923 | |
| 2 | 11265 | |
| 5 | 3271 | 5.4% |
| 9 | 1662 | 2.7% |
| 3 | 1495 | 2.5% |
| 8 | 1303 | 2.1% |
| 4 | 1203 | 2.0% |
| 7 | 1160 | 1.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 48696 | |
| Dash Punctuation | 12174 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 14263 | |
| 1 | 11923 | |
| 2 | 11265 | |
| 5 | 3271 | 6.7% |
| 9 | 1662 | 3.4% |
| 3 | 1495 | 3.1% |
| 8 | 1303 | 2.7% |
| 4 | 1203 | 2.5% |
| 7 | 1160 | 2.4% |
| 6 | 1151 | 2.4% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 12174 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 60870 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 14263 | |
| - | 12174 | |
| 1 | 11923 | |
| 2 | 11265 | |
| 5 | 3271 | 5.4% |
| 9 | 1662 | 2.7% |
| 3 | 1495 | 2.5% |
| 8 | 1303 | 2.1% |
| 4 | 1203 | 2.0% |
| 7 | 1160 | 1.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 60870 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 14263 | |
| - | 12174 | |
| 1 | 11923 | |
| 2 | 11265 | |
| 5 | 3271 | 5.4% |
| 9 | 1662 | 2.7% |
| 3 | 1495 | 2.5% |
| 8 | 1303 | 2.1% |
| 4 | 1203 | 2.0% |
| 7 | 1160 | 1.9% |
interest_frequency
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 95.1 KiB |
| 2.0 | |
|---|---|
| 4.0 | 500 |
| 12.0 | 2 |
| 1.0 | 2 |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.0003286 |
| Min length | 3 |
Characters and Unicode
| Total characters | 18263 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2.0 |
|---|---|
| 2nd row | 2.0 |
| 3rd row | 2.0 |
| 4th row | 2.0 |
| 5th row | 2.0 |
Common Values
| Value | Count | Frequency (%) |
| 2.0 | 5583 | |
| 4.0 | 500 | 8.2% |
| 12.0 | 2 | < 0.1% |
| 1.0 | 2 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2.0 | 5583 | |
| 4.0 | 500 | 8.2% |
| 12.0 | 2 | < 0.1% |
| 1.0 | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 6087 | |
| 0 | 6087 | |
| 2 | 5585 | |
| 4 | 500 | 2.7% |
| 1 | 4 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 12176 | |
| Other Punctuation | 6087 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 6087 | |
| 2 | 5585 | |
| 4 | 500 | 4.1% |
| 1 | 4 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 6087 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 18263 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| . | 6087 | |
| 0 | 6087 | |
| 2 | 5585 | |
| 4 | 500 | 2.7% |
| 1 | 4 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 18263 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| . | 6087 | |
| 0 | 6087 | |
| 2 | 5585 | |
| 4 | 500 | 2.7% |
| 1 | 4 | < 0.1% |
coupon
Real number (ℝ)
| Distinct | 1236 |
|---|---|
| Distinct (%) | 20.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.1243181 |
| Minimum | 0.13925 |
|---|---|
| Maximum | 15 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 95.1 KiB |
Quantile statistics
| Minimum | 0.13925 |
|---|---|
| 5-th percentile | 0.955025 |
| Q1 | 2.198 |
| median | 3.012 |
| Q3 | 3.9 |
| 95-th percentile | 5.625 |
| Maximum | 15 |
| Range | 14.86075 |
| Interquartile range (IQR) | 1.702 |
Descriptive statistics
| Standard deviation | 1.4319076 |
|---|---|
| Coefficient of variation (CV) | 0.45831044 |
| Kurtosis | 2.4004671 |
| Mean | 3.1243181 |
| Median Absolute Deviation (MAD) | 0.863 |
| Skewness | 0.87779548 |
| Sum | 19017.724 |
| Variance | 2.0503594 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3.5 | 147 | 2.4% |
| 4 | 119 | 2.0% |
| 3.25 | 115 | 1.9% |
| 3 | 109 | 1.8% |
| 2.75 | 107 | 1.8% |
| 2.5 | 98 | 1.6% |
| 3.75 | 93 | 1.5% |
| 2.25 | 91 | 1.5% |
| 2 | 83 | 1.4% |
| 3.375 | 82 | 1.3% |
| Other values (1226) | 5043 |
| Value | Count | Frequency (%) |
| 0.13925 | 1 | |
| 0.2036 | 1 | |
| 0.2116 | 1 | |
| 0.218 | 1 | |
| 0.23285 | 1 | |
| 0.25 | 1 | |
| 0.2716 | 1 | |
| 0.28435 | 1 | |
| 0.3 | 1 | |
| 0.309 | 2 |
| Value | Count | Frequency (%) |
| 15 | 1 | < 0.1% |
| 12.5 | 1 | < 0.1% |
| 10.125 | 1 | < 0.1% |
| 9.875 | 1 | < 0.1% |
| 9.75 | 4 | |
| 9.625 | 1 | < 0.1% |
| 9.5 | 4 | |
| 9.15 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
| 8.875 | 3 |
pay_in_kind
Boolean
HIGH CORRELATION  IMBALANCE  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 2502 |
| Missing (%) | 41.1% |
| Memory size | 59.4 KiB |
| False | |
|---|---|
| True | 1 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 3584 | |
| True | 1 | < 0.1% |
| (Missing) | 2502 |
coupon_change_indicator
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 95.1 KiB |
| N | |
|---|---|
| F | 502 |
| CFFL | 261 |
| T | 71 |
| U | 9 |
| Other values (2) | 4 |
Length
| Max length | 4 |
|---|---|
| Median length | 1 |
| Mean length | 1.1286348 |
| Min length | 1 |
Characters and Unicode
| Total characters | 6870 |
|---|---|
| Distinct characters | 8 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | N |
|---|---|
| 2nd row | N |
| 3rd row | N |
| 4th row | N |
| 5th row | N |
Common Values
| Value | Count | Frequency (%) |
| N | 5240 | |
| F | 502 | 8.2% |
| CFFL | 261 | 4.3% |
| T | 71 | 1.2% |
| U | 9 | 0.1% |
| S | 3 | < 0.1% |
| R | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| n | 5240 | |
| f | 502 | 8.2% |
| cffl | 261 | 4.3% |
| t | 71 | 1.2% |
| u | 9 | 0.1% |
| s | 3 | < 0.1% |
| r | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 5240 | |
| F | 1024 | 14.9% |
| C | 261 | 3.8% |
| L | 261 | 3.8% |
| T | 71 | 1.0% |
| U | 9 | 0.1% |
| S | 3 | < 0.1% |
| R | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 6870 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 5240 | |
| F | 1024 | 14.9% |
| C | 261 | 3.8% |
| L | 261 | 3.8% |
| T | 71 | 1.0% |
| U | 9 | 0.1% |
| S | 3 | < 0.1% |
| R | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 6870 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 5240 | |
| F | 1024 | 14.9% |
| C | 261 | 3.8% |
| L | 261 | 3.8% |
| T | 71 | 1.0% |
| U | 9 | 0.1% |
| S | 3 | < 0.1% |
| R | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6870 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 5240 | |
| F | 1024 | 14.9% |
| C | 261 | 3.8% |
| L | 261 | 3.8% |
| T | 71 | 1.0% |
| U | 9 | 0.1% |
| S | 3 | < 0.1% |
| R | 1 | < 0.1% |
day_count_basis
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 95.1 KiB |
| 30/360 | |
|---|---|
| ACT/360 | 496 |
Length
| Max length | 7 |
|---|---|
| Median length | 6 |
| Mean length | 6.0814851 |
| Min length | 6 |
Characters and Unicode
| Total characters | 37018 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 30/360 |
|---|---|
| 2nd row | 30/360 |
| 3rd row | 30/360 |
| 4th row | 30/360 |
| 5th row | 30/360 |
Common Values
| Value | Count | Frequency (%) |
| 30/360 | 5591 | |
| ACT/360 | 496 | 8.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 30/360 | 5591 | |
| act/360 | 496 | 8.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 11678 | |
| 0 | 11678 | |
| / | 6087 | |
| 6 | 6087 | |
| A | 496 | 1.3% |
| C | 496 | 1.3% |
| T | 496 | 1.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 29443 | |
| Other Punctuation | 6087 | 16.4% |
| Uppercase Letter | 1488 | 4.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 11678 | |
| 0 | 11678 | |
| 6 | 6087 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 496 | |
| C | 496 | |
| T | 496 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 6087 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 35530 | |
| Latin | 1488 | 4.0% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 3 | 11678 | |
| 0 | 11678 | |
| / | 6087 | |
| 6 | 6087 |
Latin
| Value | Count | Frequency (%) |
| A | 496 | |
| C | 496 | |
| T | 496 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 37018 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 3 | 11678 | |
| 0 | 11678 | |
| / | 6087 | |
| 6 | 6087 | |
| A | 496 | 1.3% |
| C | 496 | 1.3% |
| T | 496 | 1.3% |
last_interest_date
Categorical
| Distinct | 2515 |
|---|---|
| Distinct (%) | 41.3% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 95.1 KiB |
| 2022-09-15 | 30 |
|---|---|
| 2030-09-15 | 28 |
| 2029-12-01 | 26 |
| 2022-03-15 | 24 |
| 2028-09-15 | 24 |
| Other values (2510) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 60860 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1563 ? |
|---|---|
| Unique (%) | 25.7% |
Sample
| 1st row | 2014-08-13 |
|---|---|
| 2nd row | 2018-08-15 |
| 3rd row | 2021-08-15 |
| 4th row | 2016-08-15 |
| 5th row | 2016-08-15 |
Common Values
| Value | Count | Frequency (%) |
| 2022-09-15 | 30 | 0.5% |
| 2030-09-15 | 28 | 0.5% |
| 2029-12-01 | 26 | 0.4% |
| 2022-03-15 | 24 | 0.4% |
| 2028-09-15 | 24 | 0.4% |
| 2021-09-15 | 24 | 0.4% |
| 2022-12-15 | 23 | 0.4% |
| 2030-07-15 | 23 | 0.4% |
| 2029-11-15 | 23 | 0.4% |
| 2025-09-15 | 22 | 0.4% |
| Other values (2505) | 5839 |
Length
| Value | Count | Frequency (%) |
| 2022-09-15 | 30 | 0.5% |
| 2030-09-15 | 28 | 0.5% |
| 2029-12-01 | 26 | 0.4% |
| 2022-03-15 | 24 | 0.4% |
| 2028-09-15 | 24 | 0.4% |
| 2021-09-15 | 24 | 0.4% |
| 2022-12-15 | 23 | 0.4% |
| 2030-07-15 | 23 | 0.4% |
| 2029-11-15 | 23 | 0.4% |
| 2025-09-15 | 22 | 0.4% |
| Other values (2505) | 5839 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 13957 | |
| 2 | 13047 | |
| - | 12172 | |
| 1 | 8997 | |
| 5 | 3318 | 5.5% |
| 3 | 2280 | 3.7% |
| 9 | 1779 | 2.9% |
| 4 | 1388 | 2.3% |
| 8 | 1365 | 2.2% |
| 7 | 1301 | 2.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 48688 | |
| Dash Punctuation | 12172 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 13957 | |
| 2 | 13047 | |
| 1 | 8997 | |
| 5 | 3318 | 6.8% |
| 3 | 2280 | 4.7% |
| 9 | 1779 | 3.7% |
| 4 | 1388 | 2.9% |
| 8 | 1365 | 2.8% |
| 7 | 1301 | 2.7% |
| 6 | 1256 | 2.6% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 12172 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 60860 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 13957 | |
| 2 | 13047 | |
| - | 12172 | |
| 1 | 8997 | |
| 5 | 3318 | 5.5% |
| 3 | 2280 | 3.7% |
| 9 | 1779 | 2.9% |
| 4 | 1388 | 2.3% |
| 8 | 1365 | 2.2% |
| 7 | 1301 | 2.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 60860 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 13957 | |
| 2 | 13047 | |
| - | 12172 | |
| 1 | 8997 | |
| 5 | 3318 | 5.5% |
| 3 | 2280 | 3.7% |
| 9 | 1779 | 2.9% |
| 4 | 1388 | 2.3% |
| 8 | 1365 | 2.2% |
| 7 | 1301 | 2.1% |
years_to_maturity
Real number (ℝ)
| Distinct | 1128 |
|---|---|
| Distinct (%) | 18.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.8593783 |
| Minimum | 1.0054795 |
|---|---|
| Maximum | 30 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 95.1 KiB |
Quantile statistics
| Minimum | 1.0054795 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 5.0164384 |
| median | 7.1369863 |
| Q3 | 10.041096 |
| 95-th percentile | 15.032055 |
| Maximum | 30 |
| Range | 28.994521 |
| Interquartile range (IQR) | 5.0246575 |
Descriptive statistics
| Standard deviation | 4.3184731 |
|---|---|
| Coefficient of variation (CV) | 0.54946752 |
| Kurtosis | 4.5253807 |
| Mean | 7.8593783 |
| Median Absolute Deviation (MAD) | 2.890411 |
| Skewness | 1.5586303 |
| Sum | 47840.036 |
| Variance | 18.64921 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5.021917808 | 174 | 2.9% |
| 10.02739726 | 160 | 2.6% |
| 10.02465753 | 156 | 2.6% |
| 3.010958904 | 136 | 2.2% |
| 5.010958904 | 133 | 2.2% |
| 10.01369863 | 132 | 2.2% |
| 10.01643836 | 130 | 2.1% |
| 5.024657534 | 115 | 1.9% |
| 10.01917808 | 114 | 1.9% |
| 10.02191781 | 109 | 1.8% |
| Other values (1118) | 4728 |
| Value | Count | Frequency (%) |
| 1.005479452 | 2 | |
| 1.008219178 | 1 | |
| 1.010958904 | 1 | |
| 1.016438356 | 1 | |
| 1.02739726 | 1 | |
| 1.147945205 | 1 | |
| 1.224657534 | 1 | |
| 1.320547945 | 1 | |
| 1.493150685 | 1 | |
| 1.495890411 | 2 |
| Value | Count | Frequency (%) |
| 30 | 1 | |
| 29.99726027 | 1 | |
| 29.99452055 | 2 | |
| 29.99178082 | 2 | |
| 29.9890411 | 1 | |
| 29.97534247 | 1 | |
| 29.96164384 | 1 | |
| 29.95068493 | 1 | |
| 29.94246575 | 1 | |
| 29.93424658 | 1 |
| issue_id | issuer_id | gross_spread | selling_concession | offering_amt | offering_price | offering_yield | principal_amt | action_price | action_amount | amount_outstanding | coupon | years_to_maturity | security_level | enhancement | coupon_type | mtn | yankee | canadian | settlement_type | comp_neg_exch_deal | rule_415_reg | sec_reg_type1 | denomination | covenants | defeased | defaulted | tender_exch_offer | redeemable | refund_protection | overallotment_opt | announced_call | active_issue | dep_eligibility | subsequent_data | fungible | action_type | see_note | interest_frequency | pay_in_kind | coupon_change_indicator | day_count_basis | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| issue_id | 1.000 | 0.110 | 0.060 | 0.091 | 0.081 | 0.014 | -0.111 | 0.061 | 0.070 | 0.038 | 0.538 | -0.039 | 0.118 | 0.041 | 0.060 | 0.123 | 0.017 | 0.055 | 0.072 | 0.022 | 0.295 | 0.799 | 0.121 | 0.043 | 0.128 | 0.014 | 0.000 | 0.202 | 0.226 | 0.026 | 0.000 | 0.036 | 0.578 | 0.074 | 0.356 | 0.374 | 0.213 | 0.000 | 0.115 | 0.706 | 0.121 | 0.197 |
| issuer_id | 0.110 | 1.000 | 0.047 | 0.083 | 0.030 | 0.029 | 0.101 | 0.018 | 0.007 | 0.107 | 0.065 | 0.091 | 0.016 | 0.056 | 0.244 | 0.143 | 0.000 | 0.245 | 0.132 | 0.000 | 0.139 | 0.078 | 0.085 | 0.130 | 0.092 | 0.000 | 0.000 | 0.090 | 0.144 | 0.000 | 0.000 | 0.000 | 0.142 | 0.000 | 0.103 | 0.113 | 0.079 | 0.000 | 0.041 | 0.077 | 0.099 | 0.073 |
| gross_spread | 0.060 | 0.047 | 1.000 | 0.962 | -0.324 | -0.285 | 0.521 | -0.065 | 0.252 | -0.324 | 0.116 | 0.550 | 0.656 | 0.107 | 0.134 | 0.335 | 0.050 | 0.318 | 0.081 | 0.000 | 0.000 | 0.121 | 0.134 | 0.112 | 0.121 | 0.000 | 0.000 | 0.104 | 0.318 | 0.000 | 0.218 | 0.060 | 0.372 | 0.050 | 0.000 | 0.053 | 0.195 | 0.000 | 0.195 | 0.000 | 0.168 | 0.342 |
| selling_concession | 0.091 | 0.083 | 0.962 | 1.000 | -0.309 | -0.386 | 0.496 | -0.027 | 0.293 | -0.328 | 0.164 | 0.534 | 0.673 | 0.129 | 0.000 | 0.324 | 0.091 | 0.198 | 0.072 | 0.000 | 0.000 | 0.119 | 0.170 | 0.099 | 0.008 | 0.000 | 0.000 | 0.102 | 0.273 | 0.000 | 0.999 | 0.000 | 0.295 | 0.000 | 0.006 | 0.007 | 0.155 | 0.000 | 0.174 | 0.000 | 0.155 | 0.299 |
| offering_amt | 0.081 | 0.030 | -0.324 | -0.309 | 1.000 | 0.093 | -0.123 | 0.050 | 0.006 | 0.484 | 0.439 | -0.099 | -0.024 | 0.009 | 0.051 | 0.052 | 0.000 | 0.159 | 0.000 | 0.000 | 0.054 | 0.044 | 0.081 | 0.067 | 0.113 | 0.000 | 0.000 | 0.105 | 0.000 | 0.000 | 0.000 | 0.000 | 0.062 | 0.000 | 0.089 | 0.083 | 0.047 | 0.050 | 0.050 | 0.000 | 0.090 | 0.100 |
| offering_price | 0.014 | 0.029 | -0.285 | -0.386 | 0.093 | 1.000 | -0.071 | 0.047 | -0.181 | 0.145 | -0.081 | -0.191 | -0.353 | 0.000 | 0.168 | 0.100 | 0.000 | 0.056 | 0.011 | 0.000 | 0.995 | 0.129 | 0.504 | 0.073 | 0.025 | 0.000 | 0.000 | 0.065 | 0.051 | 0.000 | 0.000 | 0.000 | 0.101 | 0.000 | 0.000 | 0.174 | 0.109 | 0.000 | 0.058 | 0.000 | 0.074 | 0.083 |
| offering_yield | -0.111 | 0.101 | 0.521 | 0.496 | -0.123 | -0.071 | 1.000 | -0.017 | 0.429 | -0.205 | 0.104 | 0.996 | 0.439 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.103 | 0.000 | 0.000 | 0.000 | 0.000 | 0.023 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.012 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| principal_amt | 0.061 | 0.018 | -0.065 | -0.027 | 0.050 | 0.047 | -0.017 | 1.000 | 0.049 | -0.028 | 0.064 | -0.018 | -0.031 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.009 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 1.000 | 0.000 | 1.000 | 0.000 | 0.000 |
| action_price | 0.070 | 0.007 | 0.252 | 0.293 | 0.006 | -0.181 | 0.429 | 0.049 | 1.000 | -0.184 | 0.183 | 0.472 | 0.352 | 0.000 | 0.052 | 0.099 | 1.000 | 0.087 | 0.000 | 0.000 | 0.275 | 0.068 | 0.097 | 0.000 | 0.000 | 1.000 | 1.000 | 0.297 | 0.000 | 1.000 | 1.000 | 0.000 | 0.297 | 0.050 | 0.062 | 0.149 | 0.437 | 1.000 | 0.076 | 1.000 | 0.000 | 0.072 |
| action_amount | 0.038 | 0.107 | -0.324 | -0.328 | 0.484 | 0.145 | -0.205 | -0.028 | -0.184 | 1.000 | -0.324 | -0.250 | -0.303 | 0.000 | 0.000 | 0.053 | 1.000 | 0.026 | 0.000 | 0.000 | 0.000 | 0.000 | 0.102 | 0.153 | 0.000 | 1.000 | 1.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.093 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.259 | 0.000 |
| amount_outstanding | 0.538 | 0.065 | 0.116 | 0.164 | 0.439 | -0.081 | 0.104 | 0.064 | 0.183 | -0.324 | 1.000 | 0.162 | 0.413 | 0.032 | 0.054 | 0.113 | 0.000 | 0.133 | 0.000 | 0.000 | 0.076 | 0.086 | 0.100 | 0.083 | 0.078 | 0.000 | 0.000 | 0.132 | 0.067 | 0.000 | 0.000 | 0.000 | 0.382 | 0.000 | 0.068 | 0.076 | 0.166 | 0.051 | 0.075 | 0.000 | 0.131 | 0.132 |
| coupon | -0.039 | 0.091 | 0.550 | 0.534 | -0.099 | -0.191 | 0.996 | -0.018 | 0.472 | -0.250 | 0.162 | 1.000 | 0.490 | 0.073 | 0.147 | 0.262 | 0.000 | 0.046 | 0.138 | 0.000 | 0.379 | 0.188 | 0.121 | 0.026 | 0.079 | 0.000 | 0.000 | 0.212 | 0.190 | 0.000 | 0.053 | 0.000 | 0.283 | 0.000 | 0.056 | 0.113 | 0.174 | 0.035 | 0.182 | 0.000 | 0.141 | 0.326 |
| years_to_maturity | 0.118 | 0.016 | 0.656 | 0.673 | -0.024 | -0.353 | 0.439 | -0.031 | 0.352 | -0.303 | 0.413 | 0.490 | 1.000 | 0.158 | 0.076 | 0.328 | 0.000 | 0.135 | 0.106 | 0.000 | 0.412 | 0.135 | 0.118 | 0.049 | 0.071 | 0.000 | 0.000 | 0.135 | 0.317 | 0.000 | 0.000 | 0.000 | 0.553 | 0.000 | 0.048 | 0.096 | 0.221 | 0.223 | 0.234 | 0.000 | 0.183 | 0.409 |
| security_level | 0.041 | 0.056 | 0.107 | 0.129 | 0.009 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.032 | 0.073 | 0.158 | 1.000 | 0.094 | 0.172 | 0.000 | 0.091 | 0.097 | 0.000 | 0.000 | 0.039 | 0.104 | 0.077 | 0.040 | 0.000 | 0.000 | 0.062 | 0.013 | 0.000 | 0.046 | 0.000 | 0.096 | 0.000 | 0.000 | 0.015 | 0.065 | 0.110 | 0.000 | 0.000 | 0.242 | 0.034 |
| enhancement | 0.060 | 0.244 | 0.134 | 0.000 | 0.051 | 0.168 | 0.000 | 0.000 | 0.052 | 0.000 | 0.054 | 0.147 | 0.076 | 0.094 | 1.000 | 0.083 | 0.000 | 0.183 | 0.015 | 0.000 | 0.153 | 0.021 | 0.176 | 0.176 | 0.026 | 0.000 | 0.000 | 0.055 | 0.031 | 0.000 | 0.000 | 0.027 | 0.027 | 0.033 | 0.000 | 0.000 | 0.088 | 0.000 | 0.020 | 0.000 | 0.109 | 0.019 |
| coupon_type | 0.123 | 0.143 | 0.335 | 0.324 | 0.052 | 0.100 | 0.000 | 0.000 | 0.099 | 0.053 | 0.113 | 0.262 | 0.328 | 0.172 | 0.083 | 1.000 | 0.000 | 0.144 | 0.022 | 0.000 | 0.055 | 0.065 | 0.144 | 0.229 | 0.030 | 0.000 | 0.000 | 0.087 | 0.368 | 0.000 | 0.000 | 0.000 | 0.171 | 0.000 | 0.015 | 0.038 | 0.269 | 0.000 | 0.774 | 0.000 | 1.000 | 0.772 |
| mtn | 0.017 | 0.000 | 0.050 | 0.091 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 1.000 | 0.000 | 1.000 | 0.000 | 0.000 |
| yankee | 0.055 | 0.245 | 0.318 | 0.198 | 0.159 | 0.056 | 0.000 | 0.000 | 0.087 | 0.026 | 0.133 | 0.046 | 0.135 | 0.091 | 0.183 | 0.144 | 0.000 | 1.000 | 0.058 | 0.000 | 0.043 | 0.023 | 0.580 | 0.562 | 0.194 | 0.000 | 0.000 | 0.000 | 0.159 | 0.000 | 0.017 | 0.046 | 0.044 | 0.000 | 0.000 | 0.072 | 0.122 | 0.000 | 0.069 | 0.000 | 0.159 | 0.065 |
| canadian | 0.072 | 0.132 | 0.081 | 0.072 | 0.000 | 0.011 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.138 | 0.106 | 0.097 | 0.015 | 0.022 | 0.000 | 0.058 | 1.000 | 0.000 | 0.020 | 0.042 | 0.565 | 0.118 | 0.008 | 0.000 | 0.000 | 0.005 | 0.046 | 0.000 | 0.000 | 0.000 | 0.042 | 0.000 | 0.010 | 0.047 | 0.066 | 0.093 | 0.033 | 0.000 | 0.028 | 0.035 |
| settlement_type | 0.022 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.008 | 0.000 | 0.000 | 0.000 | 0.010 | 0.000 | 0.007 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| comp_neg_exch_deal | 0.295 | 0.139 | 0.000 | 0.000 | 0.054 | 0.995 | 1.000 | 0.000 | 0.275 | 0.000 | 0.076 | 0.379 | 0.412 | 0.000 | 0.153 | 0.055 | 0.000 | 0.043 | 0.020 | 0.000 | 1.000 | 0.191 | 0.720 | 0.119 | 0.000 | 0.000 | 0.000 | 0.097 | 0.000 | 0.000 | 0.000 | 0.000 | 0.054 | 0.037 | 0.000 | 0.153 | 0.130 | 0.000 | 0.047 | 0.000 | 0.055 | 0.048 |
| rule_415_reg | 0.799 | 0.078 | 0.121 | 0.119 | 0.044 | 0.129 | 0.000 | 0.000 | 0.068 | 0.000 | 0.086 | 0.188 | 0.135 | 0.039 | 0.021 | 0.065 | 0.000 | 0.023 | 0.042 | 0.000 | 0.191 | 1.000 | 0.172 | 0.081 | 0.104 | 0.000 | 0.000 | 0.095 | 0.174 | 0.000 | 0.000 | 0.000 | 0.159 | 0.042 | 0.187 | 0.044 | 0.188 | 0.000 | 0.138 | 0.000 | 0.161 | 0.141 |
| sec_reg_type1 | 0.121 | 0.085 | 0.134 | 0.170 | 0.081 | 0.504 | 0.000 | 0.009 | 0.097 | 0.102 | 0.100 | 0.121 | 0.118 | 0.104 | 0.176 | 0.144 | 0.000 | 0.580 | 0.565 | 0.000 | 0.720 | 0.172 | 1.000 | 0.174 | 0.161 | 0.000 | 0.000 | 0.106 | 0.167 | 0.000 | 0.000 | 0.060 | 0.147 | 0.028 | 0.039 | 0.159 | 0.071 | 0.000 | 0.028 | 0.000 | 0.069 | 0.067 |
| denomination | 0.043 | 0.130 | 0.112 | 0.099 | 0.067 | 0.073 | 0.103 | 0.000 | 0.000 | 0.153 | 0.083 | 0.026 | 0.049 | 0.077 | 0.176 | 0.229 | 0.000 | 0.562 | 0.118 | 0.000 | 0.119 | 0.081 | 0.174 | 1.000 | 0.279 | 0.000 | 0.000 | 0.065 | 0.231 | 0.013 | 0.050 | 0.041 | 0.091 | 0.000 | 0.000 | 0.103 | 0.044 | 0.000 | 0.050 | 0.000 | 0.116 | 0.083 |
| covenants | 0.128 | 0.092 | 0.121 | 0.008 | 0.113 | 0.025 | 0.000 | 0.000 | 0.000 | 0.000 | 0.078 | 0.079 | 0.071 | 0.040 | 0.026 | 0.030 | 0.000 | 0.194 | 0.008 | 0.000 | 0.000 | 0.104 | 0.161 | 0.279 | 1.000 | 0.000 | 0.000 | 0.000 | 0.232 | 0.000 | 0.000 | 0.000 | 0.042 | 0.036 | 0.091 | 0.028 | 0.084 | 0.073 | 0.053 | 0.000 | 0.078 | 0.024 |
| defeased | 0.014 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 1.000 | 0.000 | 1.000 | 0.000 | 0.000 |
| defaulted | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| tender_exch_offer | 0.202 | 0.090 | 0.104 | 0.102 | 0.105 | 0.065 | 0.000 | 0.000 | 0.297 | 0.000 | 0.132 | 0.212 | 0.135 | 0.062 | 0.055 | 0.087 | 0.000 | 0.000 | 0.005 | 0.000 | 0.097 | 0.095 | 0.106 | 0.065 | 0.000 | 0.000 | 0.000 | 1.000 | 0.052 | 0.000 | 0.000 | 0.022 | 0.104 | 0.000 | 0.000 | 0.084 | 0.774 | 0.000 | 0.040 | 0.000 | 0.115 | 0.046 |
| redeemable | 0.226 | 0.144 | 0.318 | 0.273 | 0.000 | 0.051 | 0.023 | 0.000 | 0.000 | 0.000 | 0.067 | 0.190 | 0.317 | 0.013 | 0.031 | 0.368 | 0.000 | 0.159 | 0.046 | 0.008 | 0.000 | 0.174 | 0.167 | 0.231 | 0.232 | 0.000 | 0.000 | 0.052 | 1.000 | 0.000 | 0.000 | 0.014 | 0.266 | 0.026 | 0.056 | 0.013 | 0.409 | 0.000 | 0.490 | 0.000 | 0.500 | 0.494 |
| refund_protection | 0.026 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.013 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 1.000 | 0.000 | 1.000 | 0.000 | 0.000 |
| overallotment_opt | 0.000 | 0.000 | 0.218 | 0.999 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.053 | 0.000 | 0.046 | 0.000 | 0.000 | 0.000 | 0.017 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.050 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.576 | 0.000 | 0.042 | 0.000 | 0.007 | 0.000 |
| announced_call | 0.036 | 0.000 | 0.060 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.093 | 0.000 | 0.000 | 0.000 | 0.000 | 0.027 | 0.000 | 0.000 | 0.046 | 0.000 | 0.000 | 0.000 | 0.000 | 0.060 | 0.041 | 0.000 | 0.000 | 0.000 | 0.022 | 0.014 | 0.000 | 0.000 | 1.000 | 0.065 | 0.000 | 0.016 | 0.000 | 0.177 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| active_issue | 0.578 | 0.142 | 0.372 | 0.295 | 0.062 | 0.101 | 0.000 | 0.000 | 0.297 | 0.000 | 0.382 | 0.283 | 0.553 | 0.096 | 0.027 | 0.171 | 0.000 | 0.044 | 0.042 | 0.010 | 0.054 | 0.159 | 0.147 | 0.091 | 0.042 | 0.000 | 0.000 | 0.104 | 0.266 | 0.000 | 0.000 | 0.065 | 1.000 | 0.038 | 0.000 | 0.077 | 0.997 | 0.000 | 0.311 | 0.000 | 0.340 | 0.310 |
| dep_eligibility | 0.074 | 0.000 | 0.050 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.050 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.033 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.037 | 0.042 | 0.028 | 0.000 | 0.036 | 0.000 | 0.000 | 0.000 | 0.026 | 0.000 | 0.000 | 0.000 | 0.038 | 1.000 | 0.047 | 0.047 | 0.036 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| subsequent_data | 0.356 | 0.103 | 0.000 | 0.006 | 0.089 | 0.000 | 0.012 | 1.000 | 0.062 | 0.000 | 0.068 | 0.056 | 0.048 | 0.000 | 0.000 | 0.015 | 1.000 | 0.000 | 0.010 | 0.007 | 0.000 | 0.187 | 0.039 | 0.000 | 0.091 | 1.000 | 0.000 | 0.000 | 0.056 | 1.000 | 0.000 | 0.016 | 0.000 | 0.047 | 1.000 | 0.142 | 0.031 | 0.000 | 0.000 | 1.000 | 0.043 | 0.000 |
| fungible | 0.374 | 0.113 | 0.053 | 0.007 | 0.083 | 0.174 | 0.000 | 0.000 | 0.149 | 0.000 | 0.076 | 0.113 | 0.096 | 0.015 | 0.000 | 0.038 | 0.000 | 0.072 | 0.047 | 0.000 | 0.153 | 0.044 | 0.159 | 0.103 | 0.028 | 0.000 | 0.000 | 0.084 | 0.013 | 0.000 | 0.000 | 0.000 | 0.077 | 0.047 | 0.142 | 1.000 | 0.140 | 0.000 | 0.000 | 0.000 | 0.063 | 0.000 |
| action_type | 0.213 | 0.079 | 0.195 | 0.155 | 0.047 | 0.109 | 0.000 | 0.000 | 0.437 | 0.000 | 0.166 | 0.174 | 0.221 | 0.065 | 0.088 | 0.269 | 0.000 | 0.122 | 0.066 | 0.000 | 0.130 | 0.188 | 0.071 | 0.044 | 0.084 | 0.000 | 0.000 | 0.774 | 0.409 | 0.000 | 0.576 | 0.177 | 0.997 | 0.036 | 0.031 | 0.140 | 1.000 | 0.000 | 0.227 | 0.100 | 0.180 | 0.397 |
| see_note | 0.000 | 0.000 | 0.000 | 0.000 | 0.050 | 0.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.051 | 0.035 | 0.223 | 0.110 | 0.000 | 0.000 | 1.000 | 0.000 | 0.093 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.073 | 1.000 | 1.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 1.000 | 0.000 | 0.000 |
| interest_frequency | 0.115 | 0.041 | 0.195 | 0.174 | 0.050 | 0.058 | 0.000 | 0.000 | 0.076 | 0.000 | 0.075 | 0.182 | 0.234 | 0.000 | 0.020 | 0.774 | 0.000 | 0.069 | 0.033 | 0.000 | 0.047 | 0.138 | 0.028 | 0.050 | 0.053 | 0.000 | 0.000 | 0.040 | 0.490 | 0.000 | 0.042 | 0.000 | 0.311 | 0.000 | 0.000 | 0.000 | 0.227 | 0.000 | 1.000 | 0.000 | 0.566 | 0.970 |
| pay_in_kind | 0.706 | 0.077 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.100 | 1.000 | 0.000 | 1.000 | 0.000 | 0.000 |
| coupon_change_indicator | 0.121 | 0.099 | 0.168 | 0.155 | 0.090 | 0.074 | 0.000 | 0.000 | 0.000 | 0.259 | 0.131 | 0.141 | 0.183 | 0.242 | 0.109 | 1.000 | 0.000 | 0.159 | 0.028 | 0.000 | 0.055 | 0.161 | 0.069 | 0.116 | 0.078 | 0.000 | 0.000 | 0.115 | 0.500 | 0.000 | 0.007 | 0.000 | 0.340 | 0.000 | 0.043 | 0.063 | 0.180 | 0.000 | 0.566 | 0.000 | 1.000 | 0.982 |
| day_count_basis | 0.197 | 0.073 | 0.342 | 0.299 | 0.100 | 0.083 | 0.000 | 0.000 | 0.072 | 0.000 | 0.132 | 0.326 | 0.409 | 0.034 | 0.019 | 0.772 | 0.000 | 0.065 | 0.035 | 0.000 | 0.048 | 0.141 | 0.067 | 0.083 | 0.024 | 0.000 | 0.000 | 0.046 | 0.494 | 0.000 | 0.000 | 0.000 | 0.310 | 0.000 | 0.000 | 0.000 | 0.397 | 0.000 | 0.970 | 0.000 | 0.982 | 1.000 |
| issue_id | issuer_id | prospectus_issuer_name | issuer_cusip | issue_cusip | issue_name | maturity | security_level | enhancement | coupon_type | mtn | asset_backed | yankee | canadian | oid | slob | issue_offered_global | settlement_type | gross_spread | selling_concession | comp_neg_exch_deal | rule_415_reg | sec_reg_type1 | offering_amt | offering_date | offering_price | offering_yield | delivery_date | unit_deal | form_of_own | denomination | principal_amt | covenants | defeased | defaulted | tender_exch_offer | redeemable | refund_protection | overallotment_opt | announced_call | active_issue | dep_eligibility | bond_type | subsequent_data | isin | fungible | complete_cusip | action_type | effective_date | action_price | action_amount | amount_outstanding | greater_of | lesser_of | see_note | dated_date | first_interest_date | interest_frequency | coupon | pay_in_kind | coupon_change_indicator | day_count_basis | last_interest_date | years_to_maturity | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 291018 | 570539.0 | 39095.0 | AT&T INC | 00206R | BB7 | GLOBAL NT | 2015-02-13 | SEN | N | F | N | N | N | N | N | N | Y | S | 2.50 | 1.5 | NEG | N | RBNA | 1000000.0 | 2012-02-08 | 99.929 | 0.89904 | 2012-02-13 | N | BE | 2/1 | 1000.0 | Y | N | N | N | Y | N | N | N | N | DCE | CDEB | Y | US00206RBB78 | N | 00206RBB7 | E | 2014-07-15 | 100.40872 | 1000000.0 | 0.0 | NaN | NaN | NaN | 2012-02-13 | 2012-08-13 | 2.0 | 0.875 | N | N | 30/360 | 2014-08-13 | 3.016438 |
| 291032 | 570533.0 | 4003.0 | SYNOVUS FINL CORP | 87161C | AJ4 | GLOBAL SR NT | 2019-02-15 | SEN | N | F | N | N | N | N | N | N | Y | S | 13.75 | 7.0 | NEG | Y | RBNA | 300000.0 | 2012-02-08 | 99.339 | 8.00024 | 2012-02-13 | N | BE | 2/1 | 1000.0 | Y | N | N | N | Y | N | N | N | N | DCE | CDEB | Y | US87161CAJ45 | Y | 87161CAJ4 | E | 2017-11-09 | 107.26500 | 300000.0 | 0.0 | NaN | NaN | NaN | 2012-02-13 | 2012-08-15 | 2.0 | 7.875 | N | N | 30/360 | 2018-08-15 | 7.024658 |
| 291034 | 570535.0 | 40357.0 | BMC SOFTWARE INC | 055921 | AB6 | GLOBAL SR NT | 2022-02-15 | SEN | N | F | N | N | N | N | N | N | Y | S | 6.50 | 4.0 | NEG | Y | S-3 | 500000.0 | 2012-02-08 | 99.468 | 4.31607 | 2012-02-13 | N | BE | 2/1 | 1000.0 | Y | N | N | Y | Y | N | N | N | N | DCE | CDEB | Y | US055921AB64 | Y | 055921AB6 | B | 2018-11-01 | 103.18500 | 46181.0 | 0.0 | NaN | NaN | NaN | 2012-02-13 | 2012-08-15 | 2.0 | 4.250 | N | N | 30/360 | 2021-08-15 | 10.027397 |
| 291043 | 570547.0 | 39095.0 | AT&T INC | 00206R | BC5 | GLOBAL NT | 2017-02-15 | SEN | N | F | N | N | N | N | N | N | Y | S | 3.50 | 2.0 | NEG | N | RBNA | 1000000.0 | 2012-02-08 | 99.880 | 1.62507 | 2012-02-13 | N | BE | 2/1 | 1000.0 | Y | N | N | N | Y | N | N | N | N | DCE | CDEB | Y | US00206RBC51 | N | 00206RBC5 | IM | 2017-02-15 | NaN | NaN | 0.0 | NaN | NaN | NaN | 2012-02-13 | 2012-08-15 | 2.0 | 1.600 | N | N | 30/360 | 2016-08-15 | 5.024658 |
| 291045 | 570549.0 | 33631.0 | AFLAC INC | 001055 | AH5 | GLOBAL SR NT | 2017-02-15 | SEN | N | F | N | N | N | N | N | N | Y | S | 6.00 | 3.5 | NEG | Y | RBNA | 400000.0 | 2012-02-08 | 99.911 | 2.66914 | 2012-02-10 | N | BE | 2/1 | 1000.0 | Y | N | N | N | Y | N | N | N | N | DCE | CDEB | Y | US001055AH52 | Y | 001055AH5 | IM | 2017-02-15 | NaN | NaN | 0.0 | NaN | NaN | NaN | 2012-02-10 | 2012-08-15 | 2.0 | 2.650 | N | N | 30/360 | 2016-08-15 | 5.024658 |
| 291046 | 570551.0 | 33631.0 | AFLAC INC | 001055 | AJ1 | GLOBAL SR NT | 2022-02-15 | SEN | N | F | N | N | N | N | N | N | Y | S | 6.50 | 4.0 | NEG | Y | RBNA | 350000.0 | 2012-02-08 | 99.820 | 4.02208 | 2012-02-10 | N | BE | 2/1 | 1000.0 | Y | N | N | N | Y | N | N | N | N | DCE | CDEB | Y | US001055AJ19 | Y | 001055AJ1 | E | 2020-01-10 | 104.25700 | 350000.0 | 0.0 | NaN | NaN | NaN | 2012-02-10 | 2012-08-15 | 2.0 | 4.000 | N | N | 30/360 | 2021-08-15 | 10.027397 |
| 291048 | 570553.0 | 39095.0 | AT&T INC | 00206R | BD3 | GLOBAL NT | 2022-02-15 | SEN | N | F | N | N | N | N | N | N | Y | S | 4.50 | 3.0 | NEG | N | RBNA | 1000000.0 | 2012-02-08 | 99.803 | 3.02298 | 2012-02-13 | N | BE | 2/1 | 1000.0 | Y | N | N | Y | Y | N | N | N | N | DCE | CDEB | Y | US00206RBD35 | Y | 00206RBD3 | B | 2020-07-23 | NaN | 1456834.0 | 0.0 | NaN | NaN | NaN | 2012-02-13 | 2012-08-15 | 2.0 | 3.000 | N | N | 30/360 | 2021-08-15 | 10.027397 |
| 291068 | 570577.0 | 36599.0 | KENNAMETAL INC | 489170 | AC4 | GLOBAL SR NT | 2022-02-15 | SEN | N | F | N | N | N | N | N | N | Y | S | 6.50 | 4.0 | NEG | Y | S-3 | 300000.0 | 2012-02-09 | 99.877 | 3.88997 | 2012-02-14 | N | BE | 2/1 | 1000.0 | Y | N | N | N | Y | N | N | N | N | DCE | CDEB | Y | US489170AC47 | Y | 489170AC4 | B | 2021-03-12 | 100.00000 | 300000.0 | 0.0 | NaN | NaN | NaN | 2012-02-14 | 2012-08-15 | 2.0 | 3.875 | N | N | 30/360 | 2021-08-15 | 10.024658 |
| 291071 | 570581.0 | 1689.0 | FREEPORT MCMORAN COPPER & GOLD INC | 35671D | AV7 | GLOBAL SR NT | 2015-02-13 | SEN | N | F | N | N | N | N | N | N | Y | S | 4.50 | 3.0 | NEG | N | RBNA | 500000.0 | 2012-02-08 | 99.857 | 1.44888 | 2012-02-13 | N | BE | 2/1 | 1000.0 | Y | N | N | N | Y | N | N | N | N | DCE | CDEB | Y | US35671DAV73 | Y | 35671DAV7 | E | 2014-12-17 | 100.17900 | 500000.0 | 0.0 | NaN | NaN | NaN | 2012-02-13 | 2012-08-13 | 2.0 | 1.400 | N | N | 30/360 | 2014-08-13 | 3.016438 |
| 291076 | 570587.0 | 1689.0 | FREEPORT MCMORAN COPPER & GOLD INC | 35671D | AW5 | GLOBAL SR NT | 2017-03-01 | SEN | N | F | N | N | N | N | N | N | Y | S | 6.00 | 3.5 | NEG | N | RBNA | 500000.0 | 2012-02-08 | 99.880 | 2.17536 | 2012-02-13 | N | BE | 2/1 | 1000.0 | Y | N | N | N | Y | N | N | N | N | DCE | CDEB | Y | US35671DAW56 | Y | 35671DAW5 | IM | 2017-03-01 | NaN | NaN | 0.0 | NaN | NaN | NaN | 2012-02-13 | 2012-09-01 | 2.0 | 2.150 | N | N | 30/360 | 2016-09-01 | 5.063014 |
| issue_id | issuer_id | prospectus_issuer_name | issuer_cusip | issue_cusip | issue_name | maturity | security_level | enhancement | coupon_type | mtn | asset_backed | yankee | canadian | oid | slob | issue_offered_global | settlement_type | gross_spread | selling_concession | comp_neg_exch_deal | rule_415_reg | sec_reg_type1 | offering_amt | offering_date | offering_price | offering_yield | delivery_date | unit_deal | form_of_own | denomination | principal_amt | covenants | defeased | defaulted | tender_exch_offer | redeemable | refund_protection | overallotment_opt | announced_call | active_issue | dep_eligibility | bond_type | subsequent_data | isin | fungible | complete_cusip | action_type | effective_date | action_price | action_amount | amount_outstanding | greater_of | lesser_of | see_note | dated_date | first_interest_date | interest_frequency | coupon | pay_in_kind | coupon_change_indicator | day_count_basis | last_interest_date | years_to_maturity | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 560106 | 1040686.0 | 41829.0 | NEXTERA ENERGY CAP HLDGS INC | 65339K | CJ7 | GLOBAL GTD DEB | 2032-07-15 | SEN | Y | F | N | N | N | N | N | N | Y | S | 6.5 | 4.0 | NEG | Y | RBNA | 1000000.0 | 2022-06-21 | 99.925 | 5.01012 | 2022-06-23 | N | BE | 2/1 | 1000.0 | Y | N | N | N | Y | N | N | N | Y | DCE | CDEB | NaN | US65339KCJ79 | Y | 65339KCJ7 | I | 2022-06-23 | NaN | NaN | 1000000.0 | NaN | NaN | NaN | 2022-06-23 | 2023-01-15 | 2.0 | 5.000 | NaN | N | 30/360 | 2032-01-15 | 10.073973 |
| 560242 | 1040832.0 | 51560.0 | TARGA RES CORP | 87612K | AA0 | GTD GLOBAL SR NT | 2027-07-01 | SEN | Y | F | N | N | N | N | N | N | Y | S | 6.0 | 3.5 | NEG | Y | S-3 | 750000.0 | 2022-06-22 | 99.849 | 5.23457 | 2022-07-07 | N | BE | 2/1 | 1000.0 | Y | N | N | N | Y | N | N | N | Y | DCE | CDEB | NaN | US87612KAA07 | Y | 87612KAA0 | I | 2022-07-07 | NaN | NaN | 750000.0 | NaN | NaN | NaN | 2022-07-07 | 2023-01-01 | 2.0 | 5.200 | NaN | N | 30/360 | 2027-01-01 | 5.027397 |
| 560270 | 1040864.0 | 33549.0 | KREDITANSTALT FUR WIEDERAUFBAU | 500769 | JU9 | GTD GLOBAL NT | 2025-06-10 | SEN | Y | F | N | N | Y | N | N | N | Y | S | 1.0 | NaN | NEG | Y | RBNA | 3000000.0 | 2022-06-23 | 99.990 | 3.12815 | 2022-06-30 | N | BE | 1/1 | 1000.0 | N | N | N | N | N | N | N | N | Y | DCE | CDEB | NaN | US500769JU96 | N | 500769JU9 | I | 2022-06-30 | NaN | NaN | 3000000.0 | NaN | NaN | NaN | 2022-06-30 | 2022-12-10 | 2.0 | 3.125 | NaN | N | 30/360 | 2024-12-10 | 2.967123 |
| 560338 | 1040939.0 | 46387.0 | EVERSOURCE ENERGY | 30040W | AR9 | GLOBAL SR NT SER Y | 2027-07-01 | SEN | N | F | N | N | N | N | N | N | Y | S | 6.0 | 3.5 | NEG | Y | RBNA | 600000.0 | 2022-06-22 | 99.880 | 4.62724 | 2022-06-27 | N | BE | 2/1 | 1000.0 | Y | N | N | N | Y | N | N | N | Y | DCE | CDEB | NaN | US30040WAR97 | Y | 30040WAR9 | I | 2022-06-27 | NaN | NaN | 600000.0 | NaN | NaN | NaN | 2022-06-27 | 2023-01-01 | 2.0 | 4.600 | NaN | N | 30/360 | 2027-01-01 | 5.027397 |
| 560341 | 1040942.0 | 46387.0 | EVERSOURCE ENERGY | 30040W | AS7 | GLOBAL SR NT SER X | 2024-06-27 | SEN | N | F | N | N | N | N | N | N | Y | S | 2.5 | 1.5 | NEG | Y | RBNA | 900000.0 | 2022-06-22 | 99.964 | 4.21896 | 2022-06-27 | N | BE | 2/1 | 1000.0 | Y | N | N | N | Y | N | N | N | Y | DCE | CDEB | NaN | US30040WAS70 | Y | 30040WAS7 | I | 2022-06-27 | NaN | NaN | 900000.0 | NaN | NaN | NaN | 2022-06-27 | 2022-12-27 | 2.0 | 4.200 | NaN | N | 30/360 | 2023-12-27 | 2.016438 |
| 560342 | 1040943.0 | 40313.0 | KLA TENCOR CORP | 482480 | AL4 | GLOBAL SR NT | 2032-07-15 | SEN | N | F | N | N | N | N | N | N | Y | S | 4.5 | 2.5 | NEG | Y | S-3 | 1000000.0 | 2022-06-21 | 99.941 | 4.65787 | 2022-06-23 | N | BE | 2/1 | 1000.0 | Y | N | N | N | Y | N | N | N | Y | DCE | CDEB | NaN | US482480AL46 | Y | 482480AL4 | I | 2022-06-23 | NaN | NaN | 1000000.0 | NaN | NaN | NaN | 2022-06-23 | 2023-01-15 | 2.0 | 4.650 | NaN | N | 30/360 | 2032-01-15 | 10.073973 |
| 560518 | 1041125.0 | 40252.0 | BIOGEN INC | 09062X | AK9 | GLOBAL SR NT | 2051-02-15 | SEN | N | F | N | N | N | N | N | N | Y | S | NaN | NaN | EXCH | Y | RBNA | 700705.0 | 2022-06-28 | 0.000 | NaN | 2022-06-28 | N | BE | 2/1 | 1000.0 | Y | N | N | N | Y | N | N | N | Y | DCE | CDEB | NaN | US09062XAK90 | N | 09062XAK9 | I | 2022-06-28 | NaN | NaN | 700705.0 | NaN | NaN | NaN | 2022-02-15 | 2022-08-15 | 2.0 | 3.250 | NaN | N | 30/360 | 2050-08-15 | 28.654795 |
| 561172 | 1042545.0 | 41081.0 | NOMURA HLDGS INC | 65535H | BE8 | GLOBAL SR NT | 2025-07-03 | SEN | N | F | N | N | Y | N | N | N | Y | S | 2.5 | NaN | NEG | Y | F-3 | 800000.0 | 2022-06-28 | 100.000 | 5.09900 | 2022-07-06 | N | BE | 200/1 | 1000.0 | Y | N | N | N | Y | N | N | N | Y | DCE | CDEB | NaN | US65535HBE80 | Y | 65535HBE8 | I | 2022-07-06 | NaN | NaN | 800000.0 | NaN | NaN | NaN | 2022-07-06 | 2023-01-03 | 2.0 | 5.099 | NaN | N | 30/360 | 2025-01-03 | 3.016438 |
| 561173 | 1042546.0 | 41081.0 | NOMURA HLDGS INC | GLOBAL | BF5 | GLOBAL SR NT | 2027-07-06 | SEN | N | F | N | N | Y | N | N | N | Y | S | 3.5 | NaN | NEG | Y | F-3 | 500000.0 | 2022-06-28 | 100.000 | 5.38600 | 2022-07-06 | N | BE | 200/1 | 1000.0 | Y | N | N | N | Y | N | N | N | Y | DCE | CDEB | NaN | US65535HBF55 | Y | GLOBALBF5 | I | 2022-07-06 | NaN | NaN | 500000.0 | NaN | NaN | NaN | 2022-07-06 | 2023-01-06 | 2.0 | 5.386 | NaN | N | 30/360 | 2027-01-06 | 5.024658 |
| 561174 | 1042547.0 | 41081.0 | NOMURA HLDGS INC | 65535H | BC2 | GLOBAL SR NT | 2029-07-06 | SEN | N | F | N | N | Y | N | N | N | Y | S | 4.0 | NaN | NEG | Y | F-3 | 600000.0 | 2022-06-28 | 100.000 | 5.60500 | 2022-07-06 | N | BE | 200/1 | 1000.0 | Y | N | N | N | Y | N | N | N | Y | DCE | CDEB | NaN | US65535HBC25 | Y | 65535HBC2 | I | 2022-07-06 | NaN | NaN | 600000.0 | NaN | NaN | NaN | 2022-07-06 | 2023-01-06 | 2.0 | 5.605 | NaN | N | 30/360 | 2029-01-06 | 7.027397 |